manipulating the POINT data type

From: "Floyd Shackelford" <floyds(at)4peakstech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: manipulating the POINT data type
Date: 2002-08-07 17:16:26
Message-ID: NDBBKEGJICMIMJHJEBCOIEDIFHAA.floyds@4peakstech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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(at)4PeaksTech(dot)com
ICQ #: 161371538
acta non verba

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ignacio Coloma 2002-08-07 18:02:39 Re: running psql in a cron job
Previous Message Wei Weng 2002-08-07 17:07:47 Re: running psql in a cron job