> [ 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 5: Have you checked our extensive FAQ?
http://www.post
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
> Works fine for me. What encoding/locale are you using?
unicode / c
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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 t u v w x y
z',' ',3);
select split_part('a b c d e
