| From: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> |
|---|---|
| To: | Daniel Gustafsson <daniel(at)yesql(dot)se>, Jonah Shafran <jonahshafran(at)gmail(dot)com> |
| Cc: | Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ISBN range table |
| Date: | 2026-11-16 20:06:46 |
| Message-ID: | 4e6c2fc9-5389-4958-a432-bb0ee5348ad0@uni-muenster.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Jonah
I was playing a bit with this patch and found something odd -- most
likely unrelated to this patch:
psql (20devel)
Type "help" for help.
postgres=# create extension isn;
CREATE EXTENSION
postgres=# with j (v1,v2) as (
values ('12345679'::issn, '9771234567898'::issn)
)
select v1,v2,v1=v2 from j;
v1 | v2 | ?column?
-----------+-----------+----------
1234-5679 | 1234-5679 | f
(1 row)
Although casting v1 and v2 display the exact same value, they compare
unequal. I understand that the input values are "different" and
therefore a comparison should return false, but displaying identical
results is a bit confusing. Unless the truncation is correct, but then
the eq operator is wrong :)
Best, Jim
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Zsolt Parragi | 2026-11-16 19:46:18 | Re: pg_regress: schedule multi-line test groups |