From: | "Nick Roosevelt" <nroose(at)thepinc(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4872: Geometric function problem |
Date: | 2009-06-22 22:02:51 |
Message-ID: | 200906222202.n5MM2psb013590@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4872
Logged by: Nick Roosevelt
Email address: nroose(at)thepinc(dot)com
PostgreSQL version: 8.2.5
Operating system: Linux
Description: Geometric function problem
Details:
I am getting bad results for distance between point and lseg. As you can
see below, the first result is correct, and the second is clearly not.
nroose_dev=> select version();
version
----------------------------------------------------------------------------
-------------------------------
PostgreSQL 8.2.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070626 (Red Hat 4.1.2-13)
(1 row)
nroose_dev=> select point(0,0) <-> lseg(point(10,-100),point(10,450));
?column?
----------
10
(1 row)
nroose_dev=> select point(0,0) <-> lseg(point(10,-100),point(11,450));
?column?
------------------
100.498756211209
(1 row)
nroose_dev=>
From | Date | Subject | |
---|---|---|---|
Next Message | TAKATSUKA Haruka | 2009-06-23 01:36:39 | GetTokenInformation() and FreeSid() at port/exec.c |
Previous Message | Magnus Hagander | 2009-06-22 19:08:52 | Re: BUG #4869: No proper initialization of OpenSSL-Engine in libpq |