Re: [HACKERS] RFD: Don't force plpgsql IN parameters to constant

Steve Prentice wrote:
> Is there a reason we force plpgsql IN parameters to constant? The 
> reason I ask is because having them mutable would go a long way in 
> easing a port from Informix's SPL. For better or worse, we have a fair 
> amount of code in SPL that does something like:
>
>    -- pObjectId is an IN parameter
>    IF pObjectId IS NULL THEN
>        pObjectId := newid();
>    END IF;
>
> I understand it may be better to use a different technique here, but 
> we have a substantial amount of SPL (40k lines) and if we could make 
> the IN parameters mutable, it would make my day.

First reaction is that it would mean we could never pass them by 
reference. I know PLPerl uses in effect pass by copy, but what does 
PLPgsql do?

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers