Postgres Pro
Downloads
Home   >   mailing lists

Get x from point? - Mailing list pgsql-sql

From Daniel Lau
Subject Get x from point?
Date
Msg-id Pine.WNT.3.96L2.1031222164938.3432G-100000@iey118.ust.hk
Whole thread Raw
Responses Re: Get x from point?
List pgsql-sql
Tree view 
Hi all,

I am wondering if we are able to extract the x-coordinate from a
point-type attribute with SQL. I have been looking for this sort of
functions from documents and websites but it seems the function does not
exist. Or, any altnernate to do so?

regards,
Daniel Lau
Hong Kong University of Science and Technology

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to preserve \n in select statement
Next
From: Richard Huxton
Date:
Subject: Re: how to preserve \n in select statement