Re: Correct place for feature requests

On Thu, Jun 25, 2015 at 3:29 PM, John R Pierce <pierce(at)hogranch(dot)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.
​