RES: [postgis-users] Double Precision Geometry

[Gustavo Oliveira]

When I tried to store something like this:

INSERT INTO map_cdc (column, column1, column2, column3, column4, column5)
VALUES (1, 1466, 264, NULL, GeometryFromText('POINT(201610.02590000001
7562744.5816000002)', -1), 2122);

the stored data appears truncated...

select * from map_cdc order by id;

column |column|column2| column3     |                  column4
|column5
-------+------+-------+-------------+---------------------------------------
--+--------
     1 | 1466 |   264 |             | SRID=-1;POINT(201610.0259
7562744.5816) |   2122


Is there any way to do this select get exactly what I store?

[]s
Gustavo

-----Mensagem original-----
De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]Em nome de
strk at refractions.net
Enviada em: quinta-feira, 4 de novembro de 2004 09:34
Para: PostGIS Users Discussion
Assunto: Re: [postgis-users] Double Precision Geometry


On Thu, Nov 04, 2004 at 09:30:08AM -0200, Gustavo Oliveira wrote:
> Hi!
>
> Is there any way to store double precision points using geometry type?
>
> []s
> Gustavo

All postgis geometries are Double Precision.
--strk;

>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users