Re: qsort again (was Re: [PERFORM] Strange Create Index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: qsort again (was Re: [PERFORM] Strange Create Index
Date
Msg-id 11801.1140205386@sss.pgh.pa.us
Whole thread Raw
In response to Re: qsort again (was Re: [PERFORM] Strange Create Index  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-hackers
Mark Lewis <mark.lewis@mir3.com> writes:
> I think we're actually on the same page here; you're right that the
> constraint above ( f(a)==f(b) iff a==b ) can't be extended to data types
> with more than 32 bits of value space.  But the constraint I listed was
> actually:

> if a==b then f(a)==f(b)

I believe Martijn had it right: the important constraint is

    f(a) > f(b) implies a > b

which implies by commutativity

    f(a) < f(b) implies a < b

and these two together imply

    a == b implies f(a) == f(b)

Now you can't do any sorting if you only have the equality rule, you
need the inequality rule.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Christian Bird
Date:
Subject: who is pgsql in cvs
Next
From: "Marc G. Fournier"
Date:
Subject: Re: who is pgsql in cvs