"Andreas Joseph Krogh" <andreak(at)officenet(dot)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