[HACKERS] split_part bug

2004-11-17 Thread John Hansen 
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 f g h i j k l m n o p q r s t u v w x y
z',' ',4);

should return a b c, and d
returns a, null, null, null

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 f g h i j k l m n o p q r s t u v w x y
z',' ',4);

should return b c, and d
returns b, c, null

... John


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

   http://archives.postgresql.org

Re: [HACKERS] split_part bug

2004-11-17 Thread Tom Lane 
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 t u v w x y
 z',' ',3);
 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);

 should return a b c, and d
 returns a, null, null, null

Works fine for me.  What encoding/locale are you using?

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [HACKERS] split_part bug

2004-11-17 Thread John Hansen 
 Works fine for me.  What encoding/locale are you using?

unicode / c


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] split_part bug

2004-11-17 Thread Tom Lane 
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 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [HACKERS] split_part bug

2004-11-17 Thread John Hansen 
 [ 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.postgresql.org/docs/faqs/FAQ.html