Re: Clarification on item on Todo List

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
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Hills 2011-10-31 15:44:02 Multiple queries in transit
Previous Message Robert Haas 2011-10-31 14:03:00 Re: So, is COUNT(*) fast now?