Re: Floating point comparison inconsistencies of the geometric types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Floating point comparison inconsistencies of the geometric types
Дата
Msg-id 1052.1464807125@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Floating point comparison inconsistencies of the geometric types  (Paul Ramsey <pramsey@cleverelephant.ca>)
Список pgsql-hackers
Paul Ramsey <pramsey@cleverelephant.ca> writes:
> One of the things people find annoying about postgis is that
> ST_Intersects(ST_Intersection(a, b), a) can come out as false (a
> derived point at a crossing of lines may not exactly intersect either
> of the input lines), which is a direct result of our use of exact math
> for the boolean intersects test.

That's an interesting comment, because it's more or less exactly the
type of failure that we could expect to get if we remove fuzzy comparisons
from the built-in types.  How much of a problem is it in practice for
PostGIS users?  Do you have any plans to change it?

> Anyways, go forth and do whatever makes sense for PgSQL

I think we're trying to figure out what that is ...
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: JSON[B] arrays are second-class citizens
Следующее
От: Robert Haas
Дата:
Сообщение: Re: PostmasterPid not marked with PGDLLIMPORT