Home > mailing lists

float to numeric(7,3) - Mailing list pgsql-novice

From	Steve Horn
Subject	float to numeric(7,3)
Date	March 10, 2012 00:52:15
Msg-id	CAFLkBaVDjWmjLOnazH=okEK7J+WSWFiTQoxGx4UG2azZCxb-tg@mail.gmail.com Whole thread Raw
Responses	Re: float to numeric(7,3) (Frank Bax <fbax@sympatico.ca>) Re: float to numeric(7,3) (Bryan Lee Nuse <nuse@uga.edu>)
List	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?

From: Gavin Flower
Date: 09 March 2012, 08:24:34
Subject: Re: How To Store Large Text Strings

From: Frank Bax
Date: 10 March 2012, 11:01:48
Subject: Re: How To Store Large Text Strings