Thread: how to split coordinates from point

Hi

How to get X and Y coordinates from point(X,Y)?

I need only X from (X,Y)


Thanks in advance

Alexander Kuprijanov <sanya-spb@list.ru> writes:
> How to get X and Y coordinates from point(X,Y)?

Subscript it.  See the next-to-last para on
http://www.postgresql.org/docs/8.3/static/functions-geometry.html

            regards, tom lane