Re: SQL feature requests

FYI, we decided we didn't want this additional capability.

---------------------------------------------------------------------------

Florian G. Pflug wrote:
> Kevin Grittner wrote:
> >>>> On Thu, Aug 23, 2007 at  3:01 PM, in message <11856.1187899268@sss.pgh.pa.us>,
> > Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> >> The only argument I've
> >> heard that carries much weight with me is that it eases porting from
> >> other DBMS's that allow this.  Are there any others besides Oracle?
> >  
> >> select * from (select f1 from t) 
> >  
> > In Sybase:
> >  
> > com.sybase.jdbc2.jdbc.SybSQLException: The derived table expression is missing a correlation name. Check derived
tablesyntax in the Reference Manual.
 
> > Error code: 11753
> > SQL state: ZZZZZ
> 
> The really funny thing is that pgsql, mysql and at least sybase
> *explicitly* dissallow the no-alias case. Which shows that
>    .) This seems to be common source of confusion and errors.
>    .) Aliasless-Subqueries wouldn't lead to ambigous grammras in those databases.
>       Otherwise, you'd expect to get some more generic syntax error, and not
>       the very explicit "No alias, but expected one".
> 
> I agree with Tom - knowing *why* the standard committee disallows that syntax -
> and why everybody except oracle chose to agree with it would be quite interesting.
> 
> greetings, Florian Pflug
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +