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 <[email protected]>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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
