Make OVERLAPS operators conform to SQL92 spec regarding NULL handling.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2000 18:38:59 +0000 (18:38 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2000 18:38:59 +0000 (18:38 +0000)
commit51bb8082f8c45a7f603238fb511e2c0f051aa7bc
tree480d3f3dda00c74727f34b29df34e23143957894
parentf1c7360310d43c2a7bf8016b4d94ad8a43ad2c0e
Make OVERLAPS operators conform to SQL92 spec regarding NULL handling.
As I read it, the spec requires a non-null result in some cases where
one of the inputs is NULL: specifically, if the other endpoint of that
interval is between the endpoints of the other interval, then the result
is known TRUE despite the missing endpoint.  The spec could've been a
lot simpler if they did not intend this behavior.
I did not force an initdb for this change, but if you don't do one you'll
still see the old strict-function behavior.
src/backend/utils/adt/date.c
src/backend/utils/adt/timestamp.c
src/include/catalog/pg_proc.h