On Sat, 9 Nov 2002, snpe wrote: > Hello, > I work with JDeveloper and PostgreSQL JDBC and I have one problem. > I get error : > sub-SELECT in FORM must have an alias > I can't change SQL command, but it is internal JDeveloper command > > Is it SQL standard (must have alias) or PostgreSQL specific ?
It looks to me to be standard. I think the appropriate portion of the grammar is: <table reference> := <derived table> [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] <derived table> := <table subquery> <correlation name> := <identifier> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org