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

[Brent Wood]

Many thanks for the wonderful support!!

Send an email before going to bed & check my email when I get up to find a
useful thread & it's fixed. A bit different to ESRI, Oracle & Infirmix
experiences!!!

You guys rock!!!!

Brent


--- Michael Fuhr <mike at fuhr.org> wrote:

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