From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | weigelt(at)metux(dot)de |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: REFERENCES error message complaint, suggestion |
Date: | 2004-03-05 14:56:01 |
Message-ID: | 200403051456.i25Eu1W05852@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Enrico Weigelt wrote:
> * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [2004-03-04 11:24:11 -0500]:
>
> <snip>
> > Double quotes are for names (identifiers). Single quotes are
> > for string literals (constants).
>
> BTW: is this general SQL syntax or just PostgeSQL ?
We follow the SQL standard on this, and I think most other vendors do as
well.
> mysql does no distinction (which is IMHO very unclean), and it gets
> even worse since mysqldump's output does it exactly the wrong way:
> identifiers in '' and string constants in "" ...
That is pretty amazing.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-05 15:01:08 | Re: sum of a time column |
Previous Message | Richard Huxton | 2004-03-05 14:45:18 | Re: Trigger Update Issue |