Steve Singer <steve@ssinger.info> wrote:
> How about
>
> To support matching of rows which include elements without a default
> B-tree operator class, the following operators are defined for composite
> type comparison:
> <literal>*=</>,
> <literal>*<></>,
> <literal>*<</>,
> <literal>*<=</>,
> <literal>*></>, and
> <literal>*>=</>.
>
> These operators compare the internal binary representation of the two
> rows. Two rows might have a different binary representation even
> though comparisons of the two rows with the equality operator is true.
> The ordering of rows under these comparision operators is deterministic
> but not otherwise meaningful. These operators are used internally for
> materialized views and might be useful for other specialized purposes
> such as replication but are not intended to be generally useful for
> writing queries.
I agree that's an improvement. Thanks!
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company