Received: from gemini.como.polimi.it (gemini.como.polimi.it [131.175.141.42]) by hub.org (8.9.1/8.9.1) with ESMTP id IAA12837 for ; Tue, 10 Nov 1998 08:40:18 -0500 (EST) (envelope-from cristian@gemini.como.polimi.it) Received: from gemini.como.polimi.it (pc-sa2.como.polimi.it [131.175.141.110]) by gemini.como.polimi.it (8.9.1/8.9.1) with ESMTP id OAA07463 for ; Tue, 10 Nov 1998 14:24:03 +0100 (MET) Sender: cristian@gemini.como.polimi.it Message-ID: <36484231.3690A878@gemini.como.polimi.it> Date: Tue, 10 Nov 1998 14:40:01 +0100 From: Christian Saldarini X-Mailer: Mozilla 4.05 [en] (X11; I; SunOS 5.5.1 i86pc) MIME-Version: 1.0 To: PSQL Subject: need information about storing methods Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I'm nowadays tryng to use postgresql to store geographical data to use them with a gis program (GRASS). The coordinates of each point are stored in a field that is a point-type. Anyone can tell me if postgress uses, for this kind of data, a storing method like HHCODE, poin-quad-trees (or anything better) , or it stores point-data like anything else? A query like this one: " SELECT coordinates FROM table WHERE coordinates @ '((1,1),1)'::circle " is executed like anything else, processing evry tuple in the table ? If so, anyone knows how to implement a more complex storing method? Thanks to all, Christian Saldarini