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 <si...@2ndquadrant.com> wrote: > On 1 February 2013 17:54, Colin Dunklau <colin.dunk...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
