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@xxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
