Re: BUG #5308: How to disable Case sensitivity on naming identifiers - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5308: How to disable Case sensitivity on naming identifiers
Date
Msg-id 20100203233732.GI3905@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #5308: How to disable Case sensitivity on naming identifiers  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #5308: How to disable Case sensitivity on naming identifiers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Bruce Momjian escribió:

> I found one place in the docs where this wasn't immediately clear, so I
> applied the attached documentation patch.

I liked Tom's suggestion better, because then you don't start
questioning about quoting key words or not.


> --- 144,150 ----
>        <primary>case sensitivity</primary>
>        <secondary>of SQL commands</secondary>
>       </indexterm>
> !     Unquoted identifier and key word names are case insensitive.  Therefore:
>   <programlisting>
>   UPDATE MY_TABLE SET A = 5;
>   </programlisting>



--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #5308: How to disable Case sensitivity on naming identifiers
Next
From: Tom Lane
Date:
Subject: Re: BUG #5308: How to disable Case sensitivity on naming identifiers