casting columns to point

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: casting columns to point
Date: 2002-02-24 05:09:40
Message-ID: Pine.NEB.4.43.0202232306530.22493-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob T 2002-02-24 05:10:02 template Database
Previous Message Alain Picard 2002-02-24 04:36:13 Re: How do I make a query return all table names?