Re: plpgsql.consistent_into - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql.consistent_into
Date
Msg-id 13490.1389767746@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql.consistent_into  (Jim Nasby <jim@nasby.net>)
Responses Re: plpgsql.consistent_into  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Jim Nasby <jim@nasby.net> writes:
> Do we actually support = right now? We already support
> v_field := field FROM table ... ;
> and I think it's a bad idea to have different meaning for = and :=.

That ship sailed a *very* long time ago.  See other thread about
documenting rather than ignoring this more-or-less-aboriginal
behavior of plpgsql.

> I have no idea if this is related or not, but I would REALLY like for this to work (doesn't in 8.4, AFAIK not in 9.1
either...)

Hm ... too tired to be sure, but I think the issue about inlining a
function of this kind has to do with whether you get the same answers
in corner cases such as subselect fetching no rows.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: plpgsql.consistent_into
Next
From: "Erik Rijkers"
Date:
Subject: Re: tests for client programs