2011/8/29 Martín Marqués <martin.marq...@gmail.com>: > El día 29 de agosto de 2011 15:28, Pavel Stehule > <pavel.steh...@gmail.com> escribió: >> 2011/8/29 Martín Marqués <martin.marq...@gmail.com>: >>> Actually, what we are trying to do is return 2 recordsets with the >>> same function call (simulate SP from SQL Server returning 2 >>> recordsets). >>> >>> I found out that I had to do PERFORM * FROM construyecursordesdequery($1, >>> query) >>> which works now, but can't run 2 different queries on the same cursor. >>> >> >> in your example you use a static cursor. > > As opposed to? I see no way to define a cursor not-static.
refcursors can be dynamic defined Pavel > > -- > Martín Marqués > select 'martin.marques' || '@' || 'gmail.com' > DBA, Programador, Administrador > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
