Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] split_part bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] split_part bug
Date: 2004-11-17 21:58:27
Message-ID: 4413.1100728707@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
John Hansen <john(at)geeknet(dot)com(dot)au> 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

In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2004-11-17 22:09:22
Subject: Re: ambiguous column names in subqueries
Previous:From: Oliver JowettDate: 2004-11-17 21:49:10
Subject: Re: ambiguous column names in subqueries

pgsql-bugs by date

Next:From: John HansenDate: 2004-11-17 22:12:48
Subject: Re: [HACKERS] split_part bug
Previous:From: John HansenDate: 2004-11-17 21:40:50
Subject: split_part bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group