Horton
Menu

Re: Odd 9.4, 9.3 buildfarm failure on s390x

Andrew Gierth <andrew@tao11.riddles.org.uk>

View thread
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Cc: Mark Wong <mark@2ndQuadrant.com>, Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org
Date: 2018-09-29T23:38:46Z
Lists: pgsql-hackers 
>>>>> "Andrew" == Andrew Dunstan <andrew.dunstan@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;

-- 
Andrew (irc:RhodiumToad)

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Allow btree comparison functions to return INT_MIN.