| 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 |