New function: area(PATH)...

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: New function: area(PATH)...
Date: 2004-05-17 21:39:31
Message-ID: AEBBC87B-A84A-11D8-85E3-000A95C705DC@chittenden.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Attached is a patch that includes the ability to get the area of a
closed path. If the path isn't closed, area() returns NULL.

test=> SELECT p, area(p) from t;
p | area
------------------------------------------+------
((0,0),(1,0),(1,1),(2,1),(2,2),(0,2)) | 3
(1 row)

I haven't teased out the inet_client_addr() patch out of my public
development repo, so that's included as well. No document changes
included because the description of the area() function args is a vague
and all encompassing "object". -sc

Attachment Content-Type Size
patch.txt text/plain 5.7 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-05-18 01:30:30 Re: new aggregate functions v1
Previous Message Magnus Hagander 2004-05-17 20:57:06 Timezone code, one more try