Thread: casting columns to point

casting columns to point

From
"Thomas T. Thai"
Date:
in my table i have a longitude column and a latitude column. i would like
to turn those two into a third column using the point data type.

how do i update the third column  via psql using the first two column?

... (longitude,latitude)::point ... doesn't seem to work.




Re: casting columns to point

From
Thomas Lockhart
Date:
> how do i update the third column  via psql using the first two column?
> ... (longitude,latitude)::point ... doesn't seem to work.

  point(long, lat)

                   - Thomas