Re: BUG #18057: unaccent removes intentional spaces

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: martin(at)schlossarek(dot)me, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18057: unaccent removes intentional spaces
Date: 2023-08-20 00:20:48
Message-ID: ZOFcYPLTTFvKpZMi@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Aug 19, 2023 at 08:08:26PM -0400, Tom Lane wrote:
> I was envisioning following SQL identifier rules, that is you double
> the double quote. Then the existing " entries would have to become
> """", which isn't much fun. But what you're suggesting would make
> both " and \ into magic characters, doubling the chance of problems
> with existing rules files.

Apologies for the confusion. I was thinking to also escape \ in
quoted strings. Your suggestion to use a second double-quote for the
escaping is fine by me. """" feels a bit ugly-ish in the rules file,
for sure, but that does not look like a huge issue to me as long as
the python script generates consistent contents ;)
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-08-20 16:12:21 Re: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected.
Previous Message Tom Lane 2023-08-20 00:08:26 Re: BUG #18057: unaccent removes intentional spaces