Re: BUG #18057: unaccent removes intentional spaces - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18057: unaccent removes intentional spaces
Date
Msg-id 2334732.1692462604@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18057: unaccent removes intentional spaces  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #18057: unaccent removes intentional spaces
List pgsql-bugs
Michael Paquier <michael@paquier.xyz> writes:
> I was looking at the code, and my first impression was right.  All
> leading and trailing whitespaces between the two characters listed in
> the rule file are discarded.  The thing is that we clearly document
> the parsing rules for the sake of any custom files one can feed to the
> extension:
> https://www.postgresql.org/docs/devel/unaccent.html

> I am not sure what we can do here.  Doing nothing is certainly an
> option, but I am wondering if we could put in place an extra rule
> where whitespaces can be part of the translated character if it uses
> double quotes, for example.  Thoughts?

Yeah, we could extend the parsing rules that way.  It would break
any rules files that currently use double quote as a plain character,
but it seems unlikely that there are any.  In any case, as long as
this wasn't back-patched I think such a change would be acceptable.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18061: The psql -v variable option does not work for the -c command option
Next
From: Vik Fearing
Date:
Subject: Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate