Re: building sets in SQL92
From: (wrong string) öder <per_at_nospam.mimer.se>
Date: 3 Jun 2001 19:02:15 GMT
Message-ID: <Xns90B5D56BF52F6pescatmimer_at_192.71.97.199>
Date: 3 Jun 2001 19:02:15 GMT
Message-ID: <Xns90B5D56BF52F6pescatmimer_at_192.71.97.199>
"James Chapman" <Jim.Chapman_at_nospam.elsegundoca.ncr.com> wrote in <3b17fbcd$1_at_rpc1284.daytonoh.ncr.com>:
>That will work in DB2, but it is not part of SQL-92.
>
>"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message
>news:9f8nt8$10ts$1_at_stlnews.stl.ibm.com...
>> values('boston') union values('ny')
>> will work
>> Thanks
>> Aakash
That construct is indeed valid in full SQL-92.
-- /Per Schröder http://developer.mimer.comReceived on Sun Jun 03 2001 - 21:02:15 CEST