Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator
Date
Msg-id ZqoIBlVvEsntf9Eu@depesz.com
Whole thread Raw
In response to BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator
Next
From: Sandeep Thakkar
Date:
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607