>>> On Thu, Aug 23, 2007 at 3:01 PM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> 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 table syntax in the Reference Manual. Error code: 11753 SQL state: ZZZZZ
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly