[postgis-users] digit problem about sql file.

[ibrahim saricicek]

Hi;

use round function

SELECT round(4.1255545487878546, 4);

result---> 4.1256

Regards...

On Thu, Feb 4, 2010 at 9:40 AM, Hyung Joo Lee <procarrie at imrc.kist.re.kr>wrote:

> Hi all.
>
> I have a question about the decimal of shapefile that was created in
> Arcgis.
>
> The file I have defined the coordinates of the coordinate system like
> (56.631 55.612)
>
> That file was put in the DB using shp2pgsql( ---# shp2pgsql -a -w -S -I
> ###.shp table_name > ###.sql).
>
> And then I checked the sql file. But the point coordinates that comes a lot
> more than 3-digit  like 56.6313000004739 55.6119999999646
>
> I want to come out only 3-digit, so how can I do?
>
> What option should I use?
>
> I'll wait for the users a clear answer.
>
>
>
> Best regards and thanks in advance.
>
> Kevin.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100204/de81140a/attachment.html>