From: | Алексей Бережняк <core(at)irc(dot)lg(dot)ua> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Correct place for feature requests |
Date: | 2015-06-25 19:52:18 |
Message-ID: | CAJHPw-MBaR0cqizZqF-Xp7__9t5_8CqTJE1abCYL_CYb5LSquQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I understand that, but it seem there are no way to use words like
"group", or "case" without enclosing them into double quotes (and
therefore making them case-sensitive).
2015-06-25 22:29 GMT+03:00 John R Pierce <pierce(at)hogranch(dot)com>:
> 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.
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2015-06-25 19:53:59 | Re: Correct place for feature requests |
Previous Message | David G. Johnston | 2015-06-25 19:39:43 | Re: Correct place for feature requests |