On 06/25/2015 12:52 PM, Алексей Бережняк wrote:
> 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).
From here:
https://technet.microsoft.com/en-us/library/ms176027%28v=sql.105%29.aspx
"
Delimited identifiers are used in the following situations:
When reserved words are used for object names or parts of object names.
Reserved keywords should not be used as object names. Databases
upgraded from earlier versions of SQL Server may contain identifiers
that include words not reserved in the earlier version, but that are
reserved words for the current version of SQL Server. You can refer to
the object by using delimited identifiers until the name can be changed. "
So in SQL Server using keywords is not considered a good idea.
From here:
https://msdn.microsoft.com/en-us/library/ms144250%28v=sql.105%29.aspx
and here:
https://msdn.microsoft.com/en-us/library/ms175874%28v=sql.100%29.aspx
it would seem case sensitivity is a determined by collation, as much as
quoting.
>
> 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
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
