Re: [HACKERS] Behavior of equality_oper and ordering_oper

2003-08-16 Thread Bruce Momjian
Sounds good to me too. --- Joe Conway wrote: > Tom Lane wrote: > > Today it occurred to me that we could look in pg_opclass for a default > > btree opclass for the datatype. If we find one, then the Equal and Less > > membe

[HACKERS] Behavior of equality_oper and ordering_oper

2003-08-15 Thread Tom Lane
There are a couple of routines in parse_oper.c that are intended to look up appropriate '=' and '<' operators given a datatype OID. These are used in quite a variety of places, for example to determine the semantics of GROUP BY. It's bothered me for some time that these routines depend on actuall

Re: [HACKERS] Behavior of equality_oper and ordering_oper

2003-08-15 Thread Joe Conway
Tom Lane wrote: Today it occurred to me that we could look in pg_opclass for a default btree opclass for the datatype. If we find one, then the Equal and Less members of the opclass are the operators we want. (If we don't find one, we could try for a default hash opclass, which would give us Equa