Clarification on item on Todo List

Lists: pgsql-hackers
From: Tristan Wright <twright09(at)earlham(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Cc: charliep(at)cs(dot)earlham(dot)edu
Subject: Clarification on item on Todo List
Date: 2011-10-28 15:46:07
Message-ID: 26093a2c-bd07-4732-ba2e-c4e7e0780a70@shee.earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I am interested in this item on the list and its exact meaning:
(Under "Data Types")
- Fix data types where equality comparison is not intuitive, e.g. box

Can you elaborate on this item, I particularly fail to see what is non-intuitive about box comparisons (and I suppose other types where equalities are non-intuitive).
-Tristan


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tristan Wright <twright09(at)earlham(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org, charliep(at)cs(dot)earlham(dot)edu
Subject: Re: Clarification on item on Todo List
Date: 2011-10-31 14:22:36
Message-ID: 26109.1320070956@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Tristan Wright <twright09(at)earlham(dot)edu> writes:
> I am interested in this item on the list and its exact meaning:
> (Under "Data Types")
> - Fix data types where equality comparison is not intuitive, e.g. box

> Can you elaborate on this item, I particularly fail to see what is non-intuitive about box comparisons (and I suppose other types where equalities are non-intuitive).

box_eq compares the boxes' areas. The operator that most people would
consider to be "equality" is box_same (~=). The reason this is on the
TODO is that nobody's figured out a way to swap the two operator names
without breaking applications.

regards, tom lane