[postgis-users] postgis help!!

Bruce Rindahl rindahl at lrcwe.com
Tue May 16 09:50:16 PDT 2006


Sorry!
I meant PostGIS versions 1.1.1 to 1.1.2!
Bruce

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Michael
Fuhr
Sent: Tuesday, May 16, 2006 10:47 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] postgis help!!

On Tue, May 16, 2006 at 10:32:36AM -0600, Bruce Rindahl wrote:
> The Translate function changed from 8.1.1 to 8.1.2.  Everyone please state
> what version of PostGIS you are using to help track this down.

Do you mean 1.0 and 1.1 (PostGIS versions, not PostgreSQL versions)?
Here's what I get for the same test case on a server running
PostgreSQL 8.0.7, PostGIS 1.0.7cvs, and GEOS 2.1.5:

CREATE TABLE foo (id serial PRIMARY KEY);
SELECT AddGeometryColumn('foo', 'geom', -1, 'GEOMETRY', 2);
INSERT INTO foo (geom) VALUES (GeomFromText('LINESTRING(-177 -44,-176
-43)'));
UPDATE foo SET geom = Translate(geom, 360.0, 0.0, 0.0);
SELECT AsText(geom), AsText(Envelope(geom)) FROM foo;
           astext            |                       astext

-----------------------------+----------------------------------------------
------
 LINESTRING(183 -44,184 -43) | POLYGON((183 -44,183 -43,184 -43,184 -44,183
-44))
(1 row)

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




More information about the postgis-users mailing list