Re: [GENERAL] Pgsql problem

2012-01-17 Thread pasman pasmański
Thanks. Hstore works perfectly. pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Pgsql problem

2012-01-12 Thread Achilleas Mantzios
On Πεμ 12 Ιαν 2012 12:51:00 pasman pasmański wrote: > Hi. > > I write function in pgsql. This function needs > to execute other functions by name. > I do it using loop: > > declare r record; > begin > for r in execute 'select ' || $1 || '()' > loop > end loop; > > But I can't convert a recor

Re: [GENERAL] Pgsql problem

2012-01-12 Thread Dmitriy Igrishin
Hey pasman, 2012/1/12 pasman pasmański > Hi. > > I write function in pgsql. This function needs > to execute other functions by name. > I do it using loop: > > declare r record; > begin > for r in execute 'select ' || $1 || '()' > loop > end loop; > > But I can't convert a record to array of t

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 ---