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

Поиск
Список
Период
Сортировка
Искать
От
hubert depesz lubaczewski
Тема
Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator
Дата
Msg-id
ZqoIBlVvEsntf9Eu@depesz.com
Ответ на
BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator (PG Bug reporting form)
Список
Дерево обсуждения
BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator PG Bug reporting form <noreply@postgresql.org>
Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Aleksander Alekseev <aleksander@timescale.com>
Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Junwang Zhao <zhjwpku@gmail.com>
Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator hubert depesz lubaczewski <depesz@depesz.com>
Re: BUG #18560: Inconsistent Behavior of PostgreSQL 'LIKE' Operator Tom Lane <tgl@sss.pgh.pa.us> 
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 по дате отправления
Предыдущее
От: Aleksander Alekseev
Дата:
Следующее
От: Sandeep Thakkar
Дата:
FAQ