Thanks, Kevin
Now being working very good
Best Regards,Salas
----- Original Message -----
From: "Kevin Neufeld" <[EMAIL PROTECTED]>
To: "fsalas" <[EMAIL PROTECTED]>; "PostGIS Users Discussion"
<[email protected]>
Sent: Wednesday, August 27, 2008 1:09 PM
Subject: Re: [postgis-users] about point and multipoint
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
___________________________________
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
