From: | Daniel Lau <iedaniel(at)ust(dot)hk> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug? (geo operator @ ) |
Date: | 2003-12-22 09:07:21 |
Message-ID: | Pine.GSO.3.95L.1031222165700.18528C-100000@uststf2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all,
I was to extract the '_lines' (path) if the lines are contained or on by a
box-like polygon. The result turns wrong if the box-like polygon is
changed from a square (x_max = y_max) to a rectangle (x_max <> y_max).
Please read the example at the end.
Please also notice that although the _lines #2 is contained by both square
and rectangle, it does not appear in both table.
I am wondering if it is a bug. Perhapes I did something wrong?
regards,
Daniel Lau
Hong Kong University of Science and Technology
Example:
_____________________________________________________________________
test=# select * from test;
geoid | _lines
-------+---------------------------------------
0 | ((0,0),(1,1))
1 | ((1,1),(0,0))
2 | ((833749,820999),(844362,821001))
3 | ((1000000,1000000),(1000001,1000001))
4 | ((0,0),(1,1),(3,-1))
(5 rows)
test=# select * from test where polygon(pclose(_lines)) @ polygon
'(-2,-2),(850000,850000)';
geoid | _lines
-------+---------------
0 | ((0,0),(1,1))
1 | ((1,1),(0,0))
(2 rows)
test=# select * from test where polygon(pclose(_lines)) @ polygon
'(-2,-2),(840000,850000)';
geoid | _lines
-------+--------
(0 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Pether | 2003-12-22 14:33:00 | Re: ecpg c++ scope operator lost |
Previous Message | Theodore Petrosky | 2003-12-21 17:52:56 | Re: make check and OSX |