Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IJeEE06603 for ; Mon, 18 Feb 2002 14:40:14 -0500 (EST) (envelope-from news@jupiter.hub.org) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1IJ2Cg89537 for pgsql-sql@postgresql.org; Mon, 18 Feb 2002 13:02:12 -0600 (CST) (envelope-from news) From: ishapiro@cogitations.com (Irv Shapiro) X-Newsgroups: comp.databases.postgresql.sql Subject: Casting pairs of floating point variables as a point in plpgsql Date: 18 Feb 2002 11:02:10 -0800 Organization: http://groups.google.com/ Lines: 35 Message-ID: <758d9f0.0202181102.77fbc9ea@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200202/280 X-Sequence-Number: 6703 I have a zip code database which includes pairs of floting point numbers representing latitude and longitude. I can retieve this data with the following query: Declare m_zip_info1 char(5); m_zip_info2 char(5); m_miles integer; m_zipcode char(5) := ''60076''; Begin select logitude, latitude into m_zip_info1, m_zip_info2 from zipstate where zipcode = m_zipcode; How do I cast the logitude and latitude floatig point numbers, stored in my plpgsql variables into a point datatype so I can use it with the earthdistance function. I tried the following and it returns a syntax error on the "as": select cast((m_zip_info1, m_zip_info2) as point) <@> cast((m_merchant_zip1, m_merchant_zip2) as point) into m_miles; I also tried the following, and Postgresql complained about the "::" select (m_zip_info1,m_zip_info2)::point <@> (m_merchant_zip1,m_merchant_zip2)::point into m_miles; Any help would be greatly appreciated. Irv ishapiro@cogitations.com