On Sun, Sep 30, 2018 at 12:38:46AM +0100, Andrew Gierth wrote: > >>>>> "Andrew" == Andrew Dunstan <andrew.duns...@2ndquadrant.com> writes: > > >> What is the size of a C "int" on this platform? > > Andrew> 4. > > Hmm. > > Because int being more than 32 bits is the simplest explanation for this > difference. > > How about the output of this query: > > with d(a) as (values ('11111111-1111-1111-1111-111111111111'::uuid), > ('22222222-2222-2222-2222-222222222222'::uuid), > ('3f3e3c3b-3a30-3938-3736-353433a2313e'::uuid)) > select d1.a, d2.a, uuid_cmp(d1.a,d2.a) from d d1, d d2 > order by d1.a asc, d2.a desc;
That also appears to produce the same results: With 9.4: postgres=# select version(); version ------------------------------------------------------------------------------------------------------------------- PostgreSQL 9.4.19 on s390x-ibm-linux-gnu, compiled by clang version 5.0.1 (tags/RELEASE_501/final 312548), 64-bit (1 row) ... a | a | uuid_cmp --------------------------------------+--------------------------------------+------------- 11111111-1111-1111-1111-111111111111 | 11111111-1111-1111-1111-111111111111 | 0 11111111-1111-1111-1111-111111111111 | 22222222-2222-2222-2222-222222222222 | -2147483648 11111111-1111-1111-1111-111111111111 | 3f3e3c3b-3a30-3938-3736-353433a2313e | -2147483648 22222222-2222-2222-2222-222222222222 | 11111111-1111-1111-1111-111111111111 | 1 22222222-2222-2222-2222-222222222222 | 22222222-2222-2222-2222-222222222222 | 0 22222222-2222-2222-2222-222222222222 | 3f3e3c3b-3a30-3938-3736-353433a2313e | -2147483648 3f3e3c3b-3a30-3938-3736-353433a2313e | 11111111-1111-1111-1111-111111111111 | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | 22222222-2222-2222-2222-222222222222 | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | 3f3e3c3b-3a30-3938-3736-353433a2313e | 0 (9 rows) Then with HEAD: postgres=# select version(); version -------------------------------------------------------------------------------------------------------------------- PostgreSQL 12devel on s390x-ibm-linux-gnu, compiled by clang version 5.0.1 (tags/RELEASE_501/final 312548), 64-bit (1 row) ... a | a | uuid_cmp --------------------------------------+--------------------------------------+------------- 11111111-1111-1111-1111-111111111111 | 11111111-1111-1111-1111-111111111111 | 0 11111111-1111-1111-1111-111111111111 | 22222222-2222-2222-2222-222222222222 | -2147483648 11111111-1111-1111-1111-111111111111 | 3f3e3c3b-3a30-3938-3736-353433a2313e | -2147483648 22222222-2222-2222-2222-222222222222 | 11111111-1111-1111-1111-111111111111 | 1 22222222-2222-2222-2222-222222222222 | 22222222-2222-2222-2222-222222222222 | 0 22222222-2222-2222-2222-222222222222 | 3f3e3c3b-3a30-3938-3736-353433a2313e | -2147483648 3f3e3c3b-3a30-3938-3736-353433a2313e | 11111111-1111-1111-1111-111111111111 | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | 22222222-2222-2222-2222-222222222222 | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | 3f3e3c3b-3a30-3938-3736-353433a2313e | 0 (9 rows) Regards, Mark -- Mark Wong http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services