On Thu, Jun 25, 2015 at 3:29 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 6/25/2015 11:59 AM, Алексей Бережняк wrote: > >> I think that PostgreSQL is great RDBMS, but one important (for me) >> feature that it missing is case-insensitive identifier quotes >> ([table].[column]) like in Microsoft SQL Server. >> > > putting names in [ ] is not part of any SQL specification. > > I know that there are double quotes, but they are case-sensitive. >> >> Or maybe some option that will make double quotes case-insensitive. >> > > the current behavior is compliant with the SQL specification. if you > want case-insensitive, don't quote the identifiers. if you do quote them, > they are implicitly case sensitive according to the specifications. all identifier comparisons are case-sensitive - but unquoted identifiers are case-folded to lower-case (in contravention of the SQL IIRC) before the comparison is made. Identifier == "identifier" but the standard says Identifier == "IDENTIFIER" David J.
