Re: [SQL] Question about geometric function area()

2004-12-19 Thread Kretschmer Andreas
am Sun, dem 19.12.2004, um 11:38:40 +0100 mailte Kretschmer Andreas folgendes: > Now, I need the area, but 'select area(koerper) from geo where id=1;' > fails. If I do 'select area(box(koerper)) from geo where id=1;' it > works, but this isn't the right answer. Is this a limitation for area()? Se

[SQL] Question about geometric function area()

2004-12-19 Thread Kretschmer Andreas
Hello, I have a table with a polygon - typ. There I stored, for instance this polygon: test_db=# select * from geo where id = 1; id | koerper +- 1 | ((0,0),(0,2),(2,2),(3,3),(5,0)) (1 Zeile) Now, I need the area, but 'select area(koerper) from