Re: [GENERAL] PgSQL problem: How to split strings into rows

2010-01-21 Thread Ivan Sergio Borgonovo
On Thu, 21 Jan 2010 13:49:45 -0500 Kynn Jones wrote: > I have a table X with some column K consisting of > whitespace-separated words. Is there some SELECT query that will > list all these words (for the entire table) so that there's one > word per row in the returned table? E.g. If the table X

Re: [GENERAL] PgSQL problem: How to split strings into rows

2010-01-21 Thread Andreas Kretschmer
Kynn Jones wrote: > I have a table X with some column K consisting of whitespace-separated words. > > Is there some SELECT query that will list all these words (for the entire > table) so that there's one word per row in the returned table? E.g. If the > table X is > >K > --

Re: [GENERAL] PgSQL problem: How to split strings into rows

2010-01-21 Thread Thomas Kellerer
Kynn Jones wrote on 21.01.2010 19:49: I have a table X with some column K consisting of whitespace-separated words. Is there some SELECT query that will list all these words (for the entire table) so that there's one word per row in the returned table? E.g. If the table X is K ---