polygon info
От | Brent Wood |
---|---|
Тема | polygon info |
Дата | |
Msg-id | Pine.OSF.4.21.0202251342330.375691-100000@neptune.niwa.cri.nz обсуждение исходный текст |
Ответ на | Re: pg_dump sequence START incorrect? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
I have a table created with an attribute of polygon datatype. 7.2 seems to have overcome a tuple size limit in 7.1.x which is nice. The doc's don't go into much detail about geometric operators & functions. Can PG return the area of a polygon? The docs suggest it can (at least for box data), but this suggests it can't. >geotest=# select area(list)from test1; >ERROR: Function 'area(polygon)' does not exist > Unable to identify a function that satisfies the given argument >types > You may need to add explicit typecasts Boxing the polygon to return the area won't quite do what I want :-) Also, is there any further info available on indexing & performance tweaking for geometric datatypes? Thanks.... ============================================================================= _-''-_ <Brent Wood> b.wood@niwa.cri.nz Ph: +64(4)386-0300 'o \/ NIWA, Box 14901, > ) /\ Kilbirnie, Wellington, New Zealand `-===-' #include <std_disclaimer>
В списке pgsql-general по дате отправления: