Re: Implied Functional Index use - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: Implied Functional Index use
Date
Msg-id E1539E0ED7043848906A8FF995BDA579012B3E36@m0143.s-mxs.net
Whole thread Raw
In response to Re: Implied Functional Index use  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
> > > - add a new boolean to pg_operator to allow us to define which
> > > operators offer true equality ...
> >
> > This would be useful for other purposes too, as we keep coming up
> > against "what's the equality operator for this datatype" problems.
> > However, the restriction to "true" equality, such that we can assume
x
> > = y implies f(x) = f(y) for every immutable function f on the
datatype

Maybe we could have a tri (or more) state flag for the equality
operators.

' ' .. not an equality op
'e' .. equality
's' .. strict equality (op only true iff the binary representation is
equal)

Andreas


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pre_load_libraries
Next
From: Simon Riggs
Date:
Subject: Re: Implied Functional Index use