| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Reshat Sabiq" <sabiq(at)purdue(dot)edu>, paul(at)entropia(dot)co(dot)uk, "'Chris Boget'" <chris(at)wild(dot)net>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Simple query question |
| Date: | 2002-12-23 18:34:48 |
| Message-ID: | sele0vc84uab0er5hp1ll7a3m6c2epudbk@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Mon, 23 Dec 2002 13:01:58 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad Thompson | 2002-12-23 19:07:44 | Comma delimited results |
| Previous Message | Michael Paesold | 2002-12-23 18:20:01 | Re: Simple query question |