Re: Simple query question

On Mon, 23 Dec 2002 13:01:58 -0500, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>         <double quote> ::= "
>         <quote> ::= '
>
>I can't believe that MySQL gets such a basic element of SQL syntax wrong

s/My/MS/  and better believe it :-)  I did this in 7.0:

CREATE TABLE tst2 (id INT, x varchar(20))
INSERT INTO tst2 VALUES (1, "one")
INSERT INTO tst2 VALUES (2, 'two')
SELECT * FROM tst2
id          x
----------- --------------------
1           one
2           two

This seems to be a common misconception among database vendors who
consider themselves leading in one sense or another.

Servus
 Manfred