Re: [HACKERS] Text Selectivity Operators in String Types

2008-08-18 Thread David E. Wheeler
On Aug 18, 2008, at 12:18, Tom Lane wrote: "David E. Wheeler" <[EMAIL PROTECTED]> writes: From what depesz sees, the eqsel and eqjoinsel functions might be a bit too aggressive in recommending the use of indexes. He presented absolutely 0 evidence to back up that opinion. So I was wondering

Re: [HACKERS] Text Selectivity Operators in String Types

2008-08-18 Thread Tom Lane
"David E. Wheeler" <[EMAIL PROTECTED]> writes: > From what depesz sees, the eqsel and eqjoinsel functions might be a > bit too aggressive in recommending the use of indexes. He presented absolutely 0 evidence to back up that opinion. > So I was wondering, since in CVS HEAD citext is able to id

[HACKERS] Text Selectivity Operators in String Types

2008-08-18 Thread David E. Wheeler
Howdy, A while back, thanks to feedback from RhodiumToad on #postgresql, I added selectivity functions to the citext operators: CREATE OPERATOR = ( LEFTARG= CITEXT, RIGHTARG = CITEXT, COMMUTATOR = =, NEGATOR= <>, PROCEDURE = citext_eq, RESTRICT = eqsel,