Re: Re: [SQL] PL/PGSQL function with parameters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florent Guillaume <efgeor(at)noos(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org, pgman(at)candle(dot)pha(dot)pa(dot)us
Subject: Re: Re: [SQL] PL/PGSQL function with parameters
Date: 2001-02-07 00:43:10
Message-ID: 26601.981506590@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Florent Guillaume <efgeor(at)noos(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-07 00:46:44 Re: Duplicate OIDs in pg_attribute
Previous Message Ross J. Reedstrom 2001-02-07 00:39:38 Re: OID from insert has extra letter

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Swan 2001-02-07 00:43:33 Re: Postgres-HOWTO
Previous Message Poet/Joshua Drake 2001-02-07 00:26:17 Re: Postgres-HOWTO