Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-11-30 14:55:18
Subject: Re: Reserved words and delimited identifiers
Previous:From: Alvaro HerreraDate: 2011-11-30 14:02:33
Subject: Re: Reserved words and delimited identifiers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group