[postgis-users] Input versus output geometry

[Alex Zepeda]

strk wrote:

> Are you sure your constraint checked your input in the original table ?

Yup.  I went over this with the postgres guys on postgres-bugs and managed
to distill something of a test case as far as the constraints being checked.
The queries I posted (courtesy of Tom Lane) produced repeatable results on
(at least) two independent machines.

# SELECT
dropbbox(ST_expand(setsrid(makepoint(-122.50367,37.74189),4326), 0.00004)) &&
dropbbox(ST_expand(setsrid(makepoint(-122.50376,37.74185),4326), 0.00004)),
ST_expand(setsrid(makepoint(-122.50367,37.74189),4326), 0.00004) &&
ST_expand(setsrid(makepoint(-122.50376,37.74185),4326), 0.00004);
  ?column? | ?column?
----------+----------
  t        | f
(1 row)


- alex