How do I Select My Polygon's Farthest Points Northeast, Northwest, Southeast, and Southwest?

[Christopher Fridlund]

Hi,

How do I select my polygon's farthest points northeast, northwest, southeast and southwest?

I've got an irregularly shaped polygon in my_table. I insterted the polygon using PolyFromtext with a bunch of lat longs.

Is there a way to query the polygon's points?

Basically, I need to call (pseudo-code) MAX(latitude), MAX(longitude), MIN(latitude), and MIN(longitude) over each of the polygon's points.

Thank you.

-Chris