Re: qsort again (was Re: [PERFORM] Strange Create Index
Greg Stark <gsstark@mit.edu>
From: Greg Stark <gsstark@mit.edu>
To: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org
Date: 2006-02-16T22:51:02Z
Lists: pgsql-hackers, pgsql-performance
Markus Schaber <schabi@logix-tt.com> writes: > Hmm, to remove redundancy, I'd change the <= to a < and define: > > if a==b then f(a)==f(b) > if a<b then f(a)<=f(b) > > > Data types which could probably provide a useful function for f would be > > int2, int4, oid, and possibly int8 and text (at least for SQL_ASCII). How exactly do you imagine doing this for text? I could see doing it for char(n)/varchar(n) where n<=4 in SQL_ASCII though. -- greg