Kis, "true news" here: http://postgis.refractions.net/documentation/manual-1.3
Fred 2009/5/22 Kis János Tamás <[email protected]> > Thank you! > > I read some false news from: > > http://webhelp.esri.com/arcgisserver/9.3/dotNet/geodatabases/st_numpoints.htm > > Thx, > kjt > > 2009/5/21, Fred Lehodey <[email protected]>: > > Hi, > > try ST_npoints(geometry) > > (ST_NumPoints(geometria) is only for linestring) > > > > > > Fred > > > > > > > > > > 2009/5/21 Kis János Tamás <[email protected]> > > > >> Hi, > >> > >> I have a big table (with 21000 rows): > >> > >> CREATE TABLE kecskemet_k.foldreszletek > >> ( sorszam bigserial NOT NULL, > >> hrsz text, > >> geometria geometry --POLYGON > >> ) WITH (OIDS=TRUE); > >> CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek > >> USING gist (geometria); > >> > >> I'd like to know, how many point exists each geometry. > >> > >> When I use the next SQL: > >> > >> SELECT hrsz, round(ST_Area(geometria)), ST_NumPoints(geometria), > >> CASE WHEN ST_NumPoints(geometria) IS NULL THEN '-' ELSE > >> else '+' END > >> FROM kecskemet_k.foldreszletek > >> ORDER BY 2 DESC > >> LIMIT 10; > >> > >> the result is: > >> hrsz | round | st_numpoints | case > >> -----------+-------+--------------+------ > >> 0118/4 | 2913 | | - > >> 01521/172 | 21738 | | - > >> 0183/27 | 2877 | | - > >> 0855/53 | 5169 | | - > >> 0413/43 | 1025 | | - > >> 094/65 | 3130 | | - > >> 0747/2 | 2877 | | - > >> 01183/4 | 326 | | - > >> 01609/79 | 2737 | | - > >> 0801/163 | 1924 | | - > >> (10 rows) > >> > >> Why I got NULL value in the st_numpoints? > >> > >> thx, > >> kjt > >> _______________________________________________ > >> postgis-users mailing list > >> [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
