If you're really concerned about output format, rather than the actual
value, consider the *to_char*() function:
select to_char (42.4734992980957, '999D999999')
--> " 42.473499"
where you also get right justification for free.
Martin Feuchtwanger [email protected] 604-254-0361
Vancouver, BC V5N 1J6
http://members.shaw.ca/geomatics.developer
On 16/04/2013 7:22 AM, Carsten Hogertz wrote:
Perfect! Thank you guys.
Carsten
2013/4/16 Hugues François <[email protected]
<mailto:[email protected]>>
And what about round(st_y(geom)::numeric, 6) ?
------------------------------------------------------------------------
*From:* [email protected]
<mailto:[email protected]>
[mailto:[email protected]
<mailto:[email protected]>] *On Behalf Of
*Carsten Hogertz
*Sent:* Tuesday, April 16, 2013 4:05 PM
*To:* PostGIS Users Discussion
*Subject:* Re: [postgis-users] Cut lat/lon to six decimal digits
Thanks.
Indead I did. I also tried
trunc(ST_Y(geom), 6)
But it gives back:
Function round(double precision, integer) does not exist
2013/4/16 Hugues François <[email protected]
<mailto:[email protected]>>
Did you simply try
round(ST_Y(geom), 6) as lat
round(ST_X(geom), 6) as lon
------------------------------------------------------------------------
*From:* [email protected]
<mailto:[email protected]>
[mailto:[email protected]
<mailto:[email protected]>] *On Behalf Of
*Carsten Hogertz
*Sent:* Tuesday, April 16, 2013 3:51 PM
*To:* PostGIS Users Discussion
*Subject:* [postgis-users] Cut lat/lon to six decimal digits
Hi everyone,
I've got the following SQL to extract the lat/lon of a polygone:
SELECT
ROW_NUMBER () over () as id,
name,
geom,
ST_Y(geom) as lat,
ST_X(geom) as lon
FROM (SELECT name, (ST_DumpPoints(geom)).* FROM
timezones20032013) as foo
It gives me back the lat and lon as a number with a lot of
digits, e.g.:
42.4734992980957
1.71096694469452
Instead what I need is:
42.473499
1.710967
How could I change my SQL to get the result cut/rounded?
Any help would be appreciated.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
