On Mar 4, 2012, at 14:52, Jan Meyland Andersen <j...@agile.dk> wrote:
> How do I return an unknown resultset from a function > > My main problem is that I do not know how many columns or the data type of > the columns before runtime. > It this possible at all? > > I also tried to return the data as a text array but I also have trouble with > that. > > Regards > > Jan > Try HSTORE. You can return RECORD from the function but the SQL user still has to define the names/types at design time. Text array should work but you lose column names which HSTORE maintains. You could also return a delimited string and then split it in the calling routine. David J -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
