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




Reply via email to