Re: record identical operator - Review - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: record identical operator - Review
Date
Msg-id 1380546492.6460.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: record identical operator - Review  (Steve Singer <steve@ssinger.info>)
Responses Re: record identical operator - Review
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: [PATCH] pg_sleep(interval)
Next
From: Peter Eisentraut
Date:
Subject: Re: [PERFORM] Cpu usage 100% on slave. s_lock problem.