Re: [GENERAL] PostgreSQL JDBC and sub-select

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>