[postgis-users] error in sentence sql

[Paragon Corporation]

Strange.  I never knew that X and Y ever too anything but a point.

Try 

ST_X(ST_Centroid(the_geom)) 

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of fsalas
Sent: Monday, July 28, 2008 3:17 PM
To: PostGIS Users Discussion
Subject: [postgis-users] error in sentence sql

Hi, in this moment i migrate my database to postgree 8.3 but my mapserver
application don´t work, when i try to execute this sentence select
X(the_geom), Y(the_geom) from consultorios,  show the error.

ERROR:  Argument to X() must be a point
********** Error **********
ERROR: Argument to X() must be a point
Estado SQL:XX000

and do not show the image map in the browser, however in Postgree 8.1, work
very well Why?

best regards Francisco salas




___________________________________
Dpto de Sistemas Informáticos
Oficina Central Grupo Empresarial GEOCUBA Este mensaje esta libre de virus. 
Revisado por Kaspersky Antivirus
----------------------------------------------------------------------
Engine version:  4.0.1.14
Engine date:  2002/06/25
Definition count:  906017
Definition date:  2008/07/28
MDAV version: 2.2.9



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