On Fri, Feb 7, 2020 at 4:53 PM PG Doc comments form <nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/functions-geometry.html > Description: > > On: https://www.postgresql.org/docs/current/functions-geometry.html > > The functions aren't defined, nor have pointers. For instance: > * Scaling/rotation box '((0,0),(1,1))' * point '(2.0,0)' > > I see how it can be scaling (or shearing), but how does it do rotation? > Or maybe when the points x^2+y^2 == 1, it's interpreted at rotation? > Google: "box point multiplication postgres" came up with the follow book section: https://books.google.com/books?id=gkQVL9pyFVYC&pg=PA95&lpg=PA95&dq=box+point+multiplication+postgres&source=bl&ots=E8z9PZHum-&sig=ACfU3U1QyE1TkI6ceUX24sQzl_zrsEH5lQ&hl=en&sa=X&ved=2ahUKEwiVhO2_48LnAhWXFzQIHVwYCXQQ6AEwAXoECAoQAQ#v=onepage&q=box%20point%20multiplication%20postgres&f=false Haven't independently confirm the math but it sounds reasonable... Each operator needs a full explanation... > Patch submissions are welcomed. David J.