Re: Re: [SQL] PL/PGSQL function with parameters - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: [SQL] PL/PGSQL function with parameters
Date
Msg-id 26601.981506590@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] PL/PGSQL function with parameters  (Florent Guillaume <efgeor@noos.fr>)
List pgsql-hackers
Florent Guillaume <efgeor@noos.fr> writes:
> On this same subject, the plpgsql doc says to use
>     SELECT expression INTO var FROM ...
> but Bruce's book, in several examples ("PL/PGSQL Functions" for instance,
> node203.html) uses
>     SELECT INTO var expression FROM ...
> Both should work, but there may be there's something to straighten up here.

IIRC, the plpgsql code is actually *very* lax about where you put the
INTO; it'll suck it out from almost anyplace in the query string ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: OID from insert has extra letter
Next
From: Tom Lane
Date:
Subject: Re: Duplicate OIDs in pg_attribute