BUG #4872: Geometric function problem

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=>

Responses

Browse pgsql-bugs by date

  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