Re: PL/PgSQL "bare" function calls - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/PgSQL "bare" function calls
Date
Msg-id 15876.1095392273@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/PgSQL "bare" function calls  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> On Fri, 2004-09-17 at 00:34, Tom Lane wrote:
>> I think Andrew has a point: why aren't they the same issue?

> (Note that we need to support CALL proc(...); in SQL for standards
> compliance in any event.)

Right.  I'm thinking we could effectively make the CALL keyword optional
(though of course this is just speculation that it can be done without
any parsing conflicts).

> Well, as it turns out, it's easy to do in PL/PgSQL as well. The SELECT
> issue you mentioned doesn't actually pose a problem, because
>     SELECT (2, 3, 4);
> is _not_ legal SQL in PL/PgSQL (PL/PgSQL requires SELECT INTO).

So?  Lookahead won't help you if the INTO is at the end.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Others applying patch queue patches
Next
From: "Katsaros Kwn/nos"
Date:
Subject: Re: Problems with SPI memory management (new...)