Re: point -> double,double ? - Mailing list pgsql-general

From Greg Stark
Subject Re: point -> double,double ?
Date
Msg-id 878yxj35ow.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: point -> double,double ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: point -> double,double ?
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Greg Stark <gsstark@mit.edu> writes:
> > What are the operators or functions to extract the x and y portions of a
> > point? I can't find it in my book or in the online \do or \df output anywhere.
>
> point[0] and point[1].  Not sure if this is adequately documented.

Thank you very much.

It may also be that I just don't have the right book. The book I have seems to
be more of a tutorial than a reference. Is there a recommended reference book
for postgres?

--
greg

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Terrible performance on wide selects
Next
From: Dennis Gearon
Date:
Subject: Constraint of only one legal value for a foreign key