Re: [JDBC] PostgreSQL JDBC and sub-select

> On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
> > snpe kirjutas L, 09.11.2002 kell 22:51:
> > > 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
> >
> > You could set up query logging in the backend and see what the offending
> > query is. It may still be something you did (a missing or extra
> > something somewhere).
> >
>
> query is like this :
> select * from (select * from tab) where 1=2
>
> This is work with Oracle,DB2,SQL Server
> Postgresql request alias in sub-select in from clause

The SQL standard requires that you alias it. Postgres follows the standard
on this:

select * from (select * from tab) as sub where 1=2;

Chris