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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
