Re: SQL construct not supported in informix ?

vk02720 <vk02720_at_my-deja.com> wrote in message news:4d814faa.0307180627.1487aadb_at_posting.google.com...
> "Art S. Kagel" <kagel_at_bloomberg.net> wrote in message
 news:<pan.2003.07.17.18.01.18.408954.15473_at_bloomberg.net>...
> > On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote:
> >
> > > The following SQL construct does not work in Informix 7.3 select a,b
> > > from
> > > (select col1 a, col2 b from mytable)
> > >
> > > This works in Oracle.
> > > Is this part of SQL standard or an Oracle extension ?
> > >
> > > TIA
> >
> > Non-standard to the level of SQL that Informix supports.
> >
> >
> > Art S. Kagel
>
> Thanks.
> So what level of SQL standard does Informix support ? And again, is
> this construct a SQL standard ( as compared to purely an Oracle
> extension ) ?

It's in SQL92, so not an Oracle extentsion (unlike that 'horrible' connect by :)

In version 7.3, you'll have to select the derived table into a temp table first and then use that in your query.

(version 8 (XPS) supports it directly - I belive, never used it, and version 9 has been covered by Kristofer)

It /ought/ to be supported, since the result of any select is just another relvar, but there you go ...

> Any good website for SQL standard ?

Tried google ? Google is your friend

--
RH