BUG #18173: ERROR: could not identify a comparison function for type unknown

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 409800246(at)qq(dot)com
Subject: BUG #18173: ERROR: could not identify a comparison function for type unknown
Date: 2023-10-30 13:24:53
Message-ID: 18173-c971c32eb961e810@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18173
Logged by: JennyJennyChen
Email address: 409800246(at)qq(dot)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=#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Kukushkin 2023-10-30 15:26:39 Re: pg_rewind WAL segments deletion pitfall
Previous Message Bruce Momjian 2023-10-30 13:09:35 Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly