Re: Correct place for feature requests
| От | David G. Johnston |
|---|---|
| Тема | Re: Correct place for feature requests |
| Дата | |
| Msg-id | CAKFQuwa39WXhzmaCY5714oCpi6no5RykCjfKCXU85vsEym2dOQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Correct place for feature requests (John R Pierce <pierce@hogranch.com>) |
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: