Hi,
sorry to bug you as an individual, but I had no replies
at all to my postings below. Can you point me to a
place/person/source where I might try to seek an answer?
Thanks.
Gautam
=======
1st posting (2nd posting attached to this email.)
========
I am trying
drop table lines;
DROP
create table lines (
l line
);
CREATE
insert into lines values ('((0,0),(1,2))'::line);
WARN:fmgr_info: function 0: cache lookup failed
EOF
If I change line to lseg everthing work ok.
I believe this is Postgres 6.3 (but I don't know how to
readily find that out on a running/installed version.
Is there a way to know by looking into some file someplace?)
Thanks
--
Gautam H. Thaker
Distributed Processing Lab; Lockheed Martin Adv. Tech. Labs
A&E 3W; 1 Federal Street; Camden, NJ 08102
609-338-3907, fax 609-338-4144 email: gthaker@atl.lmco.com
template1=> select '(0,0)'::point ## '((2,0),(0,2))'::lseg as
closest_point;
closest_point
-------------
(1,1)
(1 row)
looks to be correct but
template1=> select '(1,1)'::point ## '((0,0),(0,2))'::lseg as
closest_point;
closest_point
-------------
(0,0)
(1 row)
seems to be in error as the closest point should be "(0,1)" on the lseg,
is it not?
(please excuse me if am totally brain dead here....)
--
Gautam H. Thaker
Distributed Processing Lab; Lockheed Martin Adv. Tech. Labs
A&E 3W; 1 Federal Street; Camden, NJ 08102
609-338-3907, fax 609-338-4144 email: gthaker@atl.lmco.com
--
Official WWW Site: http://www.postgresql.org
Online Docs & FAQ: http://www.postgresql.org/docs
Searchable Lists: http://www.postgresql.org/mhonarc
