Re: SQL construct not supported in informix ?

From: vk02720 <vk02720_at_my-deja.com>
Date: 18 Jul 2003 07:27:16 -0700
Message-ID: <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 ) ?
Any good website for SQL standard ? Received on Fri Jul 18 2003 - 16:27:16 CEST

Original text of this message