float to numeric(7,3)

From: Steve Horn <steve(at)stevehorn(dot)cc>
To: pgsql-novice(at)postgresql(dot)org
Subject: float to numeric(7,3)
Date: 2012-03-10 01:51:54
Message-ID: CAFLkBaVDjWmjLOnazH=okEK7J+WSWFiTQoxGx4UG2azZCxb-tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Have a very simple question, but cannot seem to find an answer anywhere.

Using the ST_Distance function from PostGIS (
http://www.postgis.org/docs/ST_Distance.html) which returns a float.

I would like to return the result of this function rounded to 3 decimal
places. What is the best way to do that?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2012-03-10 12:01:28 Re: How To Store Large Text Strings
Previous Message Michael Lush 2012-03-09 08:33:50 Re: How To Store Large Text Strings