Quick Links

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

From:	hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To:	ammmkilo(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject:	Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator
Date:	2024-07-31 09:46:46
Message-ID:	ZqoIBlVvEsntf9Eu@depesz.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
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

In response to

BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator at 2024-07-31 04:47:23 from PG Bug reporting form

Responses

Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator at 2024-07-31 14:35:06 from Tom Lane

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Sandeep Thakkar	2024-07-31 09:53:42	Re: [EXTERNAL] Re: Windows Application Issues \| PostgreSQL \| REF # 48475607
Previous Message	Aleksander Alekseev	2024-07-31 09:19:59	Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator