Re: Questions about indexes with text_pattern_ops - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Questions about indexes with text_pattern_ops
Date
Msg-id 744.1203965616@sss.pgh.pa.us
Whole thread Raw
In response to Re: Questions about indexes with text_pattern_ops  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> It may be more right in an abstract ideal world -- the reality is that text
> collation is annoyingly complex. But this may be a case where we can get away
> with just eliding this hassle.

If anyone actually complains about it, I think we can point to the SQL
spec, which unambiguously says that a multicolumn sort key is considered
one column at a time.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Leonardo Cezar"
Date:
Subject: Re: One more option for pg_dump...
Next
From: Tom Lane
Date:
Subject: Re: Strange behavior with leap dates and centuries BC