[postgis-users] regarding count query on multiple column in one go

[Yamini Singh]

Hi Leo,
Thanks for the help. 
I tried with
the query sent by you and the resultant table I got is something as in fig1 attached.
But now I have another problem to merge line strings having same name i.e.,
Thames in attachment and get the single record with merged geometry. I used the
following query but it only gives me the geometry column.

 

SELECT
ST_AsText(ST_LineMerge(geom))

INTO
public.merge11

FROM (SELECT
ST_Union(geom) AS geom

FROM hyd_net
WHERE gid = 20 OR gid = 21) AS 

geom;

 

Please forgive
if I am making some silly mistakes as I am new to database and PostGIS as well.
Thanks and Regards,

Yamini  		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110228/e8d6d3c6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fig1.jpg
Type: image/jpeg
Size: 215438 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110228/e8d6d3c6/attachment.jpg>