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@hogranch.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general