ST_X() and ST_Y() expect the input to be a point, not a multipoint.
You'll need to explode your collection into a list of points.
Try this:
SELECT ST_X(geom), ST_Y(geom)
FROM
(SELECT (ST_Dump(geoloc)).geom
FROM consultorios) AS foo;
-- Kevin
fsalas wrote:
Hi,
How I can obtain the X,Y coordinates in one Multipoint table.
When I try to execute this
select ST_X(geoloc), ST_Y(geoloc) from consultorios
PostgreeSql/Postgis show the error
ERROR: Argument to X() must be a point
ERROR: Argument to X() must be a point
Best Regards,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:
1025598 Definition date: 2008/08/27 MDAV version: 2.2.9
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
