If you are looking at it in PgAdmin III, it looks empty but isn't. That's just a limitation of pgadmin. You also want to order your points by the way so they go into the make line aggregate in the right order.
To make sure it is not empty do this check - if it returns false then you are fine, if it returns blank or true then you are not fine. SELECT Max(f.ogc_fid) as newgid,ST_IsEmpty(ST_MakeLine(f.wkb_geometry)) As isempty FROM (SELECT ogc_fid , wkb_geometry FROM track_points where ogc_fid<1000 ORDER BY ogc_fid) AS f -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Reena Sent: Friday, August 29, 2008 6:15 AM To: [email protected] Subject: [postgis-users] Problem in getting geometry data SELECT Max(f.ogc_fid) as newgid,ST_MakeLine(f.wkb_geometry) As newgeom FROM (SELECT ogc_fid , wkb_geometry FROM track_points where ogc_fid<1020) AS f This gives newgeom only for ogc_fid<1020. If I omit this constraint or give value above 1020 ,den newgeom column is empty....what can be the problem..Can any1 suggest something Cheers, Reena. -- View this message in context: http://www.nabble.com/Problem-in-getting-geometry-data-tp19217253p192172 53.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
