operator @> does not work with box.

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: operator @> does not work with box.
Date: 2010-09-02 05:50:13
Message-ID: AANLkTino+GOHU=TzOOaE8zN3FhpLKfHNDiynb5z0UxOV@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I do

select circle '((0,0),3)' @> point '(0,0)';

and I get true.

I do

select box '((0,0),(1,1))' @> point '(0,0)';

and I get this:

ERROR: operator does not exist: box @> point
ROW 1: select box '((0,0),(1,1))' @> point '(0,0)';
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.

I'm using 8.4.4 and I feel confused. What am I doing wrong here?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Henk van Lingen 2010-09-02 08:23:33 Re: Forcing the right queryplan
Previous Message Mladen Gogala 2010-09-02 03:53:52 Re: Create or replace row in table