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>