Re: plpgsql and schema

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Roberto Pellagatti <roberto(dot)pellagatti(at)ropelsoftware(dot)fastwebnet(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql and schema
Date: 2005-06-23 18:30:16
Message-ID: 20050623183015.GA38017@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-06-23 18:40:00 Version 1.43 of DBD::Pg released
Previous Message Douglas McNaught 2005-06-23 18:16:01 Re: multi-languages in a table