Re: Reserved words and delimited identifiers

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

In response to

Responses

Browse pgsql-hackers by date

  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