Home > mailing lists

how can I select into an array? - Mailing list pgsql-general

From	Andy Kriger
Subject	how can I select into an array?
Date	February 6, 2004 14:35:18
Msg-id	200402061555.i16Ft6G29410@server1.greaterthanone.com Whole thread Raw
Responses	Re: how can I select into an array? (Pavel Stehule <stehule@kix.fsv.cvut.cz>) Re: how can I select into an array? (Tom Lane <tgl@sss.pgh.pa.us>) Re: how can I select into an array? ("Andy Kriger" <akriger@greaterthanone.com>)
List	pgsql-general

Tree view

I would like to select strings from a table and return them as an array
For example,
select new_array(name) from my_tbl
would return
String[] { name1, name2, name3, etc }

Is this possible with built-in SQL/psql functions?
If not, how hard would it be to write a function that does this? (given that I have coding experience but none writing pgsql functions)

pgsql-general by date:

From: "Peter Alberer"
Date: 06 February 2004, 14:30:02
Subject: Re: Run 2 versions of Postgresql on one machine?

From: Richard Huxton
Date: 06 February 2004, 14:42:35
Subject: Re: newbie question... how do I get table structure?

how can I select into an array? - Mailing list pgsql-general

Previous

Next