[postgis-users] polygon minimum width

[Surya Tarigan]

Dear Simon,

the previous SQL ((select row_number() over (order by the_geom) as rin) gave good result, meanwhile the second SQL ( (select ctid as rin, the_geom) still return '0' min_width.  But I still need to check my river polyline, because both min and max give exactly  the  same result, which it should not..

After I run :

select row_number() over (order by the_geom) as rin, the_geom
  from River r
  where r.Name = 'Barito';
 
it gave result something like :
rin, the_geom
1; -----(empty)---
2;-----(empty)---
3;010500000000........
4;010500000000.............
5;010500000.........
 
could it be caused by empty the_geom in rin 1 and 2?
 
kind regards,
 
sury


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091014/084e0838/attachment.html>