Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

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.

In response to

Responses

Browse pgsql-general by date

  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