Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8D6AE475A5B for ; Wed, 7 Aug 2002 13:15:09 -0400 (EDT) Received: from truckmaster.com (truckmaster.com [204.134.205.67]) by postgresql.org (Postfix) with SMTP id 68E1A475A2E for ; Wed, 7 Aug 2002 13:15:08 -0400 (EDT) Received: (qmail 2387 invoked by uid 0); 7 Aug 2002 17:15:06 -0000 Received: from floyds.truckmaster.com (HELO PECAN) (10.0.0.8) by truckmaster.com with SMTP; 7 Aug 2002 17:15:06 -0000 Reply-To: From: "Floyd Shackelford" To: Subject: manipulating the POINT data type Date: Wed, 7 Aug 2002 11:16:26 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/148 X-Sequence-Number: 8994 how do i manipulate the POINT data type in a select statement? how do i reference the X and Y portions of the point? for instance, can i select the X or Y portion of a POINT? can i do something like "select pointa.x" or "where pointa.x = pointb.x"? When using JDBC, when i get a POINT value from a result set, what am i getting? a java.awt.Point or a string? Regards, Floyd Shackelford 4 Peaks Technology Group, Inc. VOICE: 334.735.9428 FAX: 916.404.7125 EMAIL: FloydS@4PeaksTech.com ICQ #: 161371538 acta non verba