[Fwd: [QUESTIONS] an apparent error in answer from "##" (closest proximity)operator]
От | Gautam H Thaker |
---|---|
Тема | [Fwd: [QUESTIONS] an apparent error in answer from "##" (closest proximity)operator] |
Дата | |
Msg-id | 35487F48.F87225D4@atl.lmco.com обсуждение исходный текст |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: