[postgis-users] Input versus output geometry

Alex Zepeda zipzippy at sonic.net
Thu Sep 2 02:24:30 PDT 2010

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.

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

More information about the postgis-users mailing list