> [ shrug... ] Works fine for me in unicode, too.
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
> Works fine for me. What encoding/locale are you using?
unicode / c
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
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 s
John Hansen <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.0b4 as released.
> 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);
> 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);
> select split_part('a b c d e f g h i j k l m n o p q r s
