Re: BUG #4647: Geometric functions reorder their parameters randomly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4647: Geometric functions reorder their parameters randomly
Date
Msg-id 11573.1234458272@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4647: Geometric functions reorder their parameters randomly  ("Juho Saarikko" <juho.saarikko@gmail.com>)
List pgsql-bugs
"Juho Saarikko" <juho.saarikko@gmail.com> writes:
> According to the online documentation, the ## operator is supposed to return
> "Closest point to first operand on second operand". However, in reality it
> seems to decide reorder its parameters as a function of them.

In the example you give, it looks like close_lseg (which close_sb
depends on) will sometimes return a point on its first argument
instead of its second one.  If you think that the problem isn't
restricted to these two operators then you need to be more complete.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #4649: unclear in create trigger - complete example
Next
From: Konstantin
Date:
Subject: Re: BUG #4648: needless deadlock on tables having foreign-key