Re: building sets in SQL92

"James Chapman" <Jim.Chapman_at_nospam.elsegundoca.ncr.com> wrote in <3b1d28a8$1_at_rpc1284.daytonoh.ncr.com>:

>> That construct is indeed valid in full SQL-92.
>>
>
>Ah, so it is. I have stared at that page in the SQL-92 document
>many times but somehow managed not to notice that the rule for
><query expression> is satisfied, several levels deeper, by
><table value constructor> .
>
>Now, noting that a table value constructor can specify multiple
>row values, an even simpler SQL statement that solves the
>problem would be:
>
>VALUES ('boston'), ('ny')

For further excersises in SQL standard levels, please try the following web site:

http://developer.mimer.com/parser/index.tml

Note that for Entry level SQL-92 compliance, all identifiers must be UPPER CASE ;-)

-- 
/Per Schröder
http://developer.mimer.com