[postgis-devel] Re: [PostGIS] #194: Different output from Transform function when used in a function vs. directly - redirected here from postgreSQL bug reporting

[PostGIS]

#194: Different output from Transform function when used in a function vs.
directly - redirected here from postgreSQL bug reporting
----------------------+-----------------------------------------------------
  Reporter:  md       |       Owner:  pramsey
      Type:  defect   |      Status:  new    
  Priority:  medium   |   Milestone:         
 Component:  postgis  |     Version:         
Resolution:           |    Keywords:         
----------------------+-----------------------------------------------------
Comment (by kneufeld):

 I can't duplicate this problem.  Running the above code sample, I get the
 same results:
 {{{
 SELECT * FROM z_coo WHERE location = 'aaa';
        x_t        |       y_t        | location
 ------------------+------------------+----------
  352043.233452746 | 5314191.37291459 | aaa
 (1 row)

 SELECT
   X(Transform(GeomFromEWKT('SRID=2285;POINT(2093904.76854
 357063.46674)'),26911)),
   Y(Transform(GeomFromEWKT('SRID=2285;POINT(2093904.76854
 357063.46674)'),26911));
         x         |        y
 ------------------+------------------
  352043.233452746 | 5314191.37291459
 (1 row)
 }}}

 Mind you, I had to correct some syntax errors to make it run at all:
 {{{
 ARRAY['aaa',bbb',ccc',ddd',eee'], 2285,26911); commit;
 }}}
 should be:
 {{{
 ARRAY['aaa','bbb','ccc','ddd','eee'], 2285,26911); commit;
 }}}


 So, this is not an issue running:
 {{{
                                 postgis_full_version
 -------------------------------------------------------------------------------------
  POSTGIS="1.4.0SVN" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.4.9, 29 Oct 2004"
 USE_STATS
 (1 row)
 }}}

 -- Kevin

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/194#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS