Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE
| От | David G. Johnston |
|---|---|
| Тема | Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE |
| Дата | |
| Msg-id | CAKFQuwZ-jgpiBicELjtY35Kk7sAg9Ae7HJsyJaV+NiPow81Mwg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE (Bryn Llewellyn <bryn@yugabyte.com>) |
| Ответы |
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE
|
| Список | pgsql-general |
On Thu, Oct 6, 2022 at 3:53 PM Bryn Llewellyn <bryn@yugabyte.com> wrote:
(3) The PG doc on quote_ident says this in large friendly letters:Quotes are added only if necessary…Notice "only". I now know that this is very much not the case. You can compose an effectively unlimited number of different examples along these lines:select quote_ident('redaktør'); → "redaktør"
create table redaktør(n int); → table successfully created
Yep, and that is precisely what would make for a good bug report. Pointing out that "if necessary" does not indeed match up with the behavior.
I suspect it is likely to get changed - everything else being discussed just detracts attention from it.
David J.
В списке pgsql-general по дате отправления: