pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomasz Myrta <jasiek@klaster.net>
To: Scott Ding <scott.ding@autodesk.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: point <-> polygon not supported?
Date: Thu, 20 Feb 2003 15:55:20 +0100
Message-ID: <3E54EC58.7090605@klaster.net> (raw)
References: <E8EF167E598AD74381DD26B7F315098A1C988D@msgpetmb1.amer.ads.autodesk.com>

Scott Ding wrote:
> I’m using version 7.3.2. I got the following error when I executed the 
> sql statement in psql:
<cut>
> Does this mean that the <-> operator does not support distance between a 
> point and a simple polygon?
No.

Try this query:
select o.oprname,t1.typname as left, t2.typname as right
from
  pg_operator o
  join pg_type t1 on (o.oprleft=t1.oid)
  join pg_type t2 on (o.oprright=t2.oid)
where oprname='<->';

Regards,
Tomasz Myrta





view thread (5+ messages)  latest in thread

Message-ID: <3E54EC58.7090605@klaster.net>
Permalink:  ../3E54EC58.7090605@klaster.net/
Also on:    postgresql.org/message-id/3E54EC58.7090605@klaster.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jasiek@klaster.net, scott.ding@autodesk.com
  Subject: Re: point <-> polygon not supported?
  In-Reply-To: <3E54EC58.7090605@klaster.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox