Hello 2012/3/4 Jan Meyland Andersen <j...@agile.dk>: > 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? >
no, or it is not possible simply. PostgreSQL is strongly typed. I know only one workaround - using refcursor http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html Regards Pavel Stehule > I also tried to return the data as a text array but I also have trouble with > that. > > Regards > > Jan > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
