You nailed it, stupid typos.
Sorry for the inconvenience, and thank you all for your assistance.
On Sun, Feb 3, 2013 at 3:33 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 1 February 2013 17:54, Colin Dunklau <colin.dunklau@gmail.com> wrote:
>
>> For the below two queries, I expect to get a result of (0.5, 0.5).
>>
>> cdunklau=# select point( polygon '((0,0),(0,1),(1,1),(0,1))');
>> point
>> -------------
>> (0.25,0.75)
>> (1 row)
>>
>
> I think you just simply mistyped the coordinates...
>
> sriggs=# select point( polygon '((0,0),(0,1),(1,1),(1,0))');
> point
> -----------
> (0.5,0.5)
> (1 row)
>
> Your last point is a duplicate of the 2nd point, so you have a
> 4-pointed triangle and hence a strange centre.
>
> --
> Simon Riggs http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services