Postgres Pro
Downloads
Home   >   mailing lists

manipulating the POINT data type - Mailing list pgsql-sql

From Floyd Shackelford
Subject manipulating the POINT data type
Date
Msg-id NDBBKEGJICMIMJHJEBCOIEDIFHAA.floyds@4peakstech.com
Whole thread Raw
Responses Re: manipulating the POINT data type
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Frank Joerdens
Date:
Subject: Re: to_char and '=' weirdness
Next
From: "John Brothers"
Date:
Subject: getting oid of an INSERT automatically