On Tue, 18 Mar 2003 [EMAIL PROTECTED] wrote:
> create temp table ab as
> select a.value as a_value, b.value as b_value
> from a left outer join b
> on a.id = b.id;
>
> for row in select * from ab loop
> return next row;
> end loop;
>
You have to use EXECUTE when creating a temp table in a function --- see
FAQ on it.
---
[EMAIL PROTECTED] wrote:
> John Duffy ([EMAIL PROTECTED]) reports a bug with a severity of 1
> The lower the number the more severe it i
John Duffy ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
plpgsql function fails on second call
Long Description
A function containing a left outer join declared to return a set works correctly when
first called. A second call
--- Bruce Momjian <[EMAIL PROTECTED]> a écrit :
>
> Your patch has been added to the PostgreSQL
> unapplied patches list at:
>
> http://momjian.postgresql.org/cgi-bin/pgpatches
>
> I will try to apply it within the next 48 hours.
Ok, thanks a lot.
Have a nice day.
Laurent
=
The m
