Re: SQL-Invoked Procedures for 8.1

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-10-09 19:26:53
Message-ID: 200410092126.53644.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > As previously mentioned, AS is already used by the SQL standard for
> > a different purpose in this context.
>
> Hm? [ reads spec ... ] Oh, you mean <generalized expression>.
> Does that actually do anything useful? It looks like it's just
> a random shortcut for a CAST expression in a parameter list.

I imagine that since a function call is the only place where the exact
type of a datum really matters and is also ambiguous in general (under
strict SQL rules, of course), they devised an abbreviated casting
syntax for it. In any case, we shouldn't use the syntax for something
else.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2004-10-09 19:27:00 postgres vulnerability
Previous Message Tony and Bryn Reina 2004-10-09 18:28:17 Re: SSL with Beta3 - "could not load root certificate file"