pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: tanghy.fnst@fujitsu.com
Cc: smithpb2250@gmail.com
Cc: peter.eisentraut@enterprisedb.com
Cc: david.zhang@highgo.ca
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Support tab completion for upper character inputs in psql
Date: Fri, 23 Apr 2021 00:17:35 -0400
Message-ID: <1282887.1619151455@sss.pgh.pa.us> (raw)
In-Reply-To: <20210423.123407.440405986257584017.horikyota.ntt@gmail.com>
References: <OS0PR01MB61131A4347D385F02F60E123FB469@OS0PR01MB6113.jpnprd01.prod.outlook.com>
	<20210423.115812.900808736988307020.horikyota.ntt@gmail.com>
	<1280270.1619147839@sss.pgh.pa.us>
	<20210423.123407.440405986257584017.horikyota.ntt@gmail.com>

Kyotaro Horiguchi <horikyota.ntt@gmail.com> writes:
> At Thu, 22 Apr 2021 23:17:19 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote in 
>> Doesn't seem like a good idea, because that locks us into an assumption
>> that the downcasing conversion doesn't change the string's physical
>> length.  There are a lot of counterexamples to that :-(.  I'm not sure

> Mmm. I didn't know of that.

The two examples I know of offhand are in German (eszett "ß" downcases to
"ss") and Turkish (dotted "Í" downcases to "i", likewise dotless "I"
downcases to "ı"; one of each of those pairs is an ASCII letter, the
other is not).  Depending on which encoding is in use, these
transformations *could* be the same number of bytes, but they could
equally well not be.  There are probably other examples.

			regards, tom lane





view thread (54+ messages)  latest in thread

Message-ID: <1282887.1619151455@sss.pgh.pa.us>
Permalink:  ../1282887.1619151455@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1282887.1619151455@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, horikyota.ntt@gmail.com, tanghy.fnst@fujitsu.com, smithpb2250@gmail.com, peter.eisentraut@enterprisedb.com, david.zhang@highgo.ca, pgsql-hackers@lists.postgresql.org
  Subject: Re: Support tab completion for upper character inputs in psql
  In-Reply-To: <1282887.1619151455@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox