From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Joe Abbate <jma(at)freedomcircle(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Reserved words and delimited identifiers |
Date: | 2011-11-30 14:35:41 |
Message-ID: | 4ED63F3D.7080706@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 11/30/2011 09:02 AM, Alvaro Herrera wrote:
> Excerpts from Joe Abbate's message of mié nov 30 02:15:09 -0300 2011:
>
>> Thanks Tom and Robert. I think I understand the problem now. I guess
>> I'll have to work around this "quirk" by dealing specially with type
>> names and not quote them when they're in the shorter list of SQL
>> Standard reserved words.
> I wonder if it would simpler to just not quote type names except when
> absolutely necessary.
>
Yeah, and very much less ugly. Ploughing through masses of unnecessary
quotes is they way to a headache. quote_ident() gets this right.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-11-30 14:55:18 | Re: Reserved words and delimited identifiers |
Previous Message | Alvaro Herrera | 2011-11-30 14:02:33 | Re: Reserved words and delimited identifiers |