minimum bounding circle for a triangle/polygon - Mailing list pgsql-sql

From George Pavlov
Subject minimum bounding circle for a triangle/polygon
Date
Msg-id 8C5B026B51B6854CBE88121DBF097A8604C28B@ehost010-33.exch010.intermedia.net
Whole thread Raw
List pgsql-sql
before i start reinventing the wheel does anyone have handy a function (or straight SQL) for calculating the centerpoint coordinates and the radius of the minimum bounding circle (not the the circumcircle) of a triangle (coordinates of 3 points given as inputs).
 
a bonus would be a generalization for any polygon, but that's probably too much.
 
thanks in advance!
 
george

This electronic message contains information from Multifamily Technology Solutions, Inc. and is confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately by telephone at (415) 348-2000 or electronic mail.

pgsql-sql by date:

Previous
From: "Aleksandr Vinokurov"
Date:
Subject: Re: Partial index and query plan
Next
From: RPK
Date:
Subject: SQL query to display like this