Обсуждение: casting columns to point

Поиск
Список
Период
Сортировка

casting columns to point

От
"Thomas T. Thai"
Дата:
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

От
Thomas Lockhart
Дата:
> 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