From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 409800246@qq.com
Subject: BUG #18173: ERROR: could not identify a comparison function for type unknown
Date: Mon, 30 Oct 2023 13:24:53 +0000
Message-ID: <18173-c971c32eb961e810@postgresql.org> (raw)
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=#
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 409800246@qq.com
Subject: Re: BUG #18173: ERROR: could not identify a comparison function for type unknown
In-Reply-To: <18173-c971c32eb961e810@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox