MySQL allows double quotes or single quotes around string literals. Back
ticks indicate identifiers.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Friday, March 05, 2004 10:12 AM
> To: weigelt@metux.de
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] REFERENCES error message complaint, suggestion
>
>
> Enrico Weigelt <weigelt@metux.de> writes:
> > * Tom Lane <tgl@sss.pgh.pa.us> [2004-03-04 11:24:11 -0500]:
> >> Double quotes are for names (identifiers). Single quotes are
> >> for string literals (constants).
>
> > BTW: is this general SQL syntax or just PostgeSQL ?
>
> This is SQL92 standard behavior. Relevant extracts from the standard:
>
> <delimited identifier> ::=
> <double quote> <delimited identifier body> <double quote>
>
> <character string literal> ::=
> [ <introducer><character set specification> ]
> <quote> [ <character representation>... ] <quote>
> [ { <separator>... <quote> [ <character
> representation>... ] <quote> }... ]
>
> <double quote> ::= "
>
> <quote> ::= '
>
> > mysql does no distinction (which is IMHO very unclean),
>
> How can they have no distinction? Suppose I write
>
> select 'col' from tab;
> select "col" from tab;
>
> If there is a column tab.col, what am I going to get in each case?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
