Horton

Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator

hubert depesz lubaczewski <depesz@depesz.com>

View thread
From: hubert depesz lubaczewski <depesz@depesz.com>
To: ammmkilo@163.com, pgsql-bugs@lists.postgresql.org
Date: 2024-07-31T09:46:46Z
Lists: pgsql-bugs 
On Wed, Jul 31, 2024 at 04:47:23AM +0000, PG Bug reporting form wrote:
> CREATE TABLE t0(c0 INT NOT NULL, c1 CHAR(1) UNIQUE);

I bet the thing is simply one more edge case that proves that one
shouldn't be using char(n) datatype:
https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_char.28n.29

Best regards,

depesz