From: Kretschmer Andreas <andreas_kretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Question about geometric function area()
Date: Sun, 19 Dec 2004 11:38:40 +0100
Message-ID: <20041219103840.GA5849@kaufbach.delug.de> (raw)
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 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()?
Version is 7.4.5.
Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas_kretschmer@despammed.com
Subject: Re: Question about geometric function area()
In-Reply-To: <20041219103840.GA5849@kaufbach.delug.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox