Re: plpgsql and schema - Mailing list pgsql-general

From Michael Fuhr
Subject Re: plpgsql and schema
Date
Msg-id 20050623183015.GA38017@winnie.fuhr.org
Whole thread Raw
In response to Re: plpgsql and schema  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Thu, Jun 23, 2005 at 09:33:27AM -0600, Michael Fuhr wrote:
>
> http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> Note what the documentation says about not being able to get the
> result of an EXECUTE query directly.  A couple of workarounds are
> mentioned.

BTW, 8.1 will have EXECUTE INTO, which stores the first row of the
result into a row variable or variable list.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: multi-languages in a table
Next
From: "Greg Sabino Mullane"
Date:
Subject: Version 1.43 of DBD::Pg released