[postgis-users] BUGFIX in affine() (was: postgis help!!)

[Michael Fuhr]

On Tue, May 16, 2006 at 07:24:12PM +0200, strk at refractions.net wrote:
> On Tue, May 16, 2006 at 11:01:58AM -0600, Bruce Rindahl wrote:
> > Is it in the envelope function or the translate function?
> 
> It's in the affine() function. Should be fixed in CVS.
> Please give it a try.

Works here with the latest code from CVS:

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