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 |
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 |