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

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.07.17.18.01.18.408954.15473@bloombe rg.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 ) ?
Any good website for SQL standard ?

vk02720 <vk02720@my-deja.com> wrote in message
news:4d814faa.0307180627.1487aadb@posting.google.c om...
> "Art S. Kagel" <kagel@bloomberg.net> wrote in message
news:<pan.2003.07.17.18.01.18.408954.15473@bloombe rg.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