-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sat, May 31, 2008 at 10:51:35PM +0530, Shantanu wrote: > Here is my real use case > > 1) We have nornal SELECT ...INTO calls in the procedure calls > 2) However we landed ourselves with the following problem > http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
[...] > Any alternatives ? Well -- according to the 8.1 docs (I don't have an 8.1 around at the moment, sorry), one of my proposals should work: > On Sat, May 31, 2008 at 8:38 AM, <[EMAIL PROTECTED]> wrote: > [...] > > Note that if you really need the dynamic command, you might put its > > result int a variable, like so: > > > > EXECUTE 'SELECT NOW()' INTO l_var; [...] (see <http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN>). Did you try that? Did it work? Regards - -- tomás -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIQ6LIBcgs9XrR2kYRAnDHAJsEz/SS7o/sIwy7dqSGSKpeVhOLlQCfetQM GSbMIG2s7DUPOIpN6xDKocQ= =Cb8o -----END PGP SIGNATURE----- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
