Re: Does Type Have = Operator? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Does Type Have = Operator?
Date
Msg-id 3B17B047-B0E2-4F4D-899E-5C13C71CD8C7@justatheory.com
Whole thread Raw
In response to Re: Does Type Have = Operator?  (Kevin Grittner <kgrittn@gmail.com>)
Responses Re: Does Type Have = Operator?  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-hackers
On May 11, 2016, at 10:19 AM, Kevin Grittner <kgrittn@gmail.com> wrote:

> As long as you don't assume too much about *what* is equal.
>
> test=# select '(1,1)(2,2)'::box = '(-4.5,1000)(-2.5,1000.5)'::box;
> ?column?
> ----------
> t
> (1 row)

Oh, well crap. Maybe I’d be better off just comparing the plain text of the expressions as Tom suggested.

David


pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Does Type Have = Operator?
Next
From: Shawn
Date:
Subject: Re: Need help debugging why autovacuum seems "stuck" -- until I use superuser to vacuum freeze pg_database