[postgis-users] Problems

[Brian Sanjeewa Rupasinghe]

I have nbuff table created with two columns; autoid serial and Geometry
column in PostGIS. After adding the_geom column, i tried to insert data
using following query:

INSERT INTO nbuff (the_geom) VALUES ((SELECT
ST_AsText(ST_ConvexHull(ST_Union(the_geom) FROM building_poly))));

However, when above query is run, it gives an error message. how can i solve
ths?


cheers, Sanjeewa.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101015/a812203e/attachment.html>