"Andreas Joseph Krogh" <andreak@officenet.no> writes:
> I create an index:
> CREATE INDEX person_lowerfullname_idx ON
> person((lower(COALESCE(firstname, '')) || lower(COALESCE(lastname, '')))
> varchar_pattern_ops);
Why are you declaring it using the varchar_pattern_ops?
The default operator set is the one you want for handling ordering. The
pattern_ops operator set is for handling things like x LIKE 'foo%'
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com