John Hansen <john (AT) geeknet (DOT) com.au> writes:
Works fine for me. What encoding/locale are you using?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

John Hansen <john (AT) geeknet (DOT) com.au> writes:
[ 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 majordomo (AT) postgresql (DOT) org

unicode / c


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

never mind me,. I broke it.....

seems my assumption that UCS2 == UTF16 was way off....

.... john


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly