how to split coordinates from point

Started by Alexander Kuprijanovover 17 years ago2 messagesgeneral
Jump to latest
#1Alexander Kuprijanov
sanya-spb@list.ru

Hi

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

I need only X from (X,Y)

Thanks in advance

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alexander Kuprijanov (#1)
Re: how to split coordinates from point

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