From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Bryn Llewellyn <bryn(at)yugabyte(dot)com> |
Cc: | Gavan Schneider <list(dot)pg(dot)gavan(at)pendari(dot)org>, Tom Lane PostgreSQL <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE |
Date: | 2022-10-06 23:01:11 |
Message-ID: | CAKFQuwZ-jgpiBicELjtY35Kk7sAg9Ae7HJsyJaV+NiPow81Mwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Oct 6, 2022 at 3:53 PM Bryn Llewellyn <bryn(at)yugabyte(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2022-10-07 00:01:31 | Re: Support logical replication of DDLs |
Previous Message | Bryn Llewellyn | 2022-10-06 22:53:48 | Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE |