John Hansen <[EMAIL PROTECTED]> writes:
>> Works fine for me.  What encoding/locale are you using?

> unicode / c

[ shrug... ]  Works fine for me in unicode, too.

u=# select split_part('a b c d e f g h i j k l m n o p q r s t u v w x y z',' 
',1);
 split_part
------------
 a
(1 row)

u=# select split_part('a b c d e f g h i j k l m n o p q r s t u v w x y z',' 
',2);
 split_part
------------
 b
(1 row)

u=# select split_part('a b c d e f g h i j k l m n o p q r s t u v w x y z',' 
',3);
 split_part
------------
 c
(1 row)

u=# select split_part('a b c d e f g h i j k l m n o p q r s t u v w x y z',' 
',4);
 split_part
------------
 d
(1 row)


                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to