| From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: REFERENCES error message complaint, suggestion |
| Date: | 2004-03-04 17:49:26 |
| Message-ID: | 20040304174925.GC17390@nibiru.metux.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* 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 ?
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 "" ...
cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT services
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
-- DSL-Zugang ab 0 Euro. -- statische IP -- UUCP -- Hosting --
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-03-04 17:49:49 | Re: clarification of postgres limitations |
| Previous Message | Phil Campaigne | 2004-03-04 17:45:43 | Re: Setting up Postgresql on Linux |