Re: Hi! (and a question) - Mailing list pgsql-novice

From Janko Richter
Subject Re: Hi! (and a question)
Date
Msg-id 409B5456.5020207@yahoo.de
Whole thread Raw
In response to Hi! (and a question)  (David Cruz <davidcrmail@yahoo.com>)
Responses Question about REF / DREF
List pgsql-novice
David Cruz wrote:
> Hello everyone!
>
> My name is David Cruz, and I'm from Bogota, Colombia.
>
> I'm Beggining with PostgreSQL, so I've been doing just
> a few simple things.
>
> I have a problem, in my database there is a table
> which has some geometric data types: (point and
> polygon) and a need some operator or function that let
> me know if the point is inside the polygon or not.
> Something like the ~ in the point inside a circle, but
> this one is inside a polygon.
>
> thanks a lot!
>
<snip/>

What PGSQL version do you are using? I found the point ~ polygon
operator in version 7.4.

Example:
  SELECT '0.5,0.5'::point @ '(-1,0),(-1,-1),(1,-1),(1,1)'::polygon;
or
  SELECT  '(-1,0),(-1,-1),(1,-1),(1,1)'::polygon ~ '0.5,0.5'::point;

Regards, Janko Richter


pgsql-novice by date:

Previous
From: David Cruz
Date:
Subject: Hi! (and a question)
Next
From: Carlos Barroso
Date:
Subject: Problem inserting more than 80 registers!?