Re: [BUGS] session variable - Mailing list pgsql-sql

From Tom Lane
Subject Re: [BUGS] session variable
Date
Msg-id 5999.1063833785@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] session variable  (miko@idocs.com (Miko O'Sullivan))
Responses Need more examples (was "session variable")  ("Miko O Sullivan" <miko@idocs.com>)
List pgsql-sql
miko@idocs.com (Miko O'Sullivan) writes:
> Unfortunately in the 7.2.x version I have available, EXECUTE does not
> allow "select into".  The docs suggests a technique for using a FOR
> loop to extract information from an EXECUTE, but the technique only
> works for finite set of expected variables, not for arbitrary values.

How do you figure that?  AFAICS "FOR" with a record variable as target
will cover any case that SELECT INTO could handle.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: cursors in plpgsql
Next
From: Gaetano Mendola
Date:
Subject: Re: Triggers Help...