X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B5AE2476030 for ; Thu, 27 Feb 2003 16:45:26 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 59848-03 for ; Thu, 27 Feb 2003 16:45:14 -0500 (EST) Received: from mailserver01.cybernet.be (mailserver01.cybernet.be [213.177.64.33]) by postgresql.org (Postfix) with ESMTP id D5030475E13 for ; Thu, 27 Feb 2003 16:00:44 -0500 (EST) Received: from cybernet.be ([213.177.66.124]) by mailserver01.cybernet.be (Sinclair ZX81 server at 3.5MHz on microdrive) with ESMTP id GPA37015; Thu, 27 Feb 2003 22:00:45 +0100 Message-ID: <3E5E7B69.63B72758@cybernet.be> Date: Thu, 27 Feb 2003 21:56:09 +0100 From: dhoubrechts X-Mailer: Mozilla 4.75 [fr] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: fr-BE, fr-FR, en MIME-Version: 1.0 To: "pgsql-interfaces@postgresql.org" Subject: use off geometric types Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/124 X-Sequence-Number: 3745 I create a db : createdb geop I log into the db : psql geo I create a table named poly : geo=# create table poly (parc varchar(15), graphic polygon); I populate the table : insert into poly values('A52','(2,1),(1,3),(2,5),(4,6),(6,4),(5,2)'); insert into poly values('A135','(3,3),(7,4),(8,2),(4,1)'); Now I would look i the first polygon overlaps the second using the varchars for retriving the poly. I could do it so : geo=# select '((2,1),(1,3),(2,5),(4,6),(6,4),(5,2))'::polygon && '((3,3),(7,4),(8,2),(4,1))'::polygon; ?column? ---------- t (1 row) Now I can I do to have something like : geo=# select graphic::polygon from poly where parc='A52' && select graphic::polygon from poly where parc='A135'; Thanks for help Didier.