Get x from point?

From: Daniel Lau <iedaniel(at)ust(dot)hk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Get x from point?
Date: 2003-12-22 08:54:01
Message-ID: Pine.WNT.3.96L2.1031222164938.3432G-100000@iey118.ust.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-12-22 09:04:11 Re: how to preserve \n in select statement
Previous Message Tom Lane 2003-12-20 18:35:26 Re: how to preserve \n in select statement