BUG #18173: ERROR: could not identify a comparison function for type iso-8859-1

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18173: ERROR: could not identify a comparison function for type iso-8859-1
Дата
Msg-id 18173-c971c32eb961e810@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18173: ERROR: could not identify a comparison function for type iso-8859-1  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18173
Logged by:          JennyJennyChen
Email address:      409800246@qq.com
PostgreSQL version: 16.0
Operating system:   CentOS Linux release 7.9 (Final)
Description:

postgres=# CREATE TABLE test_v(id int,name varchar(30));
CREATE TABLE
postgres=# insert into test_v values(9,'abc'),(9,'def'),(9,'gh'),
(9,'gh');
INSERT 0 4
postgres=# explain (costs off) select distinct
(id,name,'D3Q84xpymM',123,'123') from test_v;
                         QUERY PLAN                          
-------------------------------------------------------------
 Unique
   ->  Sort
         Sort Key: (ROW(id, name, 'D3Q84xpymM', 123, '123'))
         ->  Seq Scan on test_v
(4 rows)

postgres=# select distinct (id,name,'D3Q84xpymM',123,'123') from test_v;
ERROR:  could not identify a comparison function for type unknown
postgres=#


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly