El día 29 de agosto de 2011 15:52, Pavel Stehule <[email protected]> escribió: > 2011/8/29 Martín Marqués <[email protected]>: >> El día 29 de agosto de 2011 15:28, Pavel Stehule >> <[email protected]> escribió: >>> 2011/8/29 Martín Marqués <[email protected]>: >>>> 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
OK, I'm totally lost. How do you define a dynamic cursor? Couldn't find anything in the manuals. -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
