pgsql/src/include/catalog (pg_proc.h) - Mailing list pgsql-committers

From tgl@postgresql.org
Subject pgsql/src/include/catalog (pg_proc.h)
Date
Msg-id 200012071838.eB7Icx892509@hub.org
Whole thread Raw
List pgsql-committers
  Date: Thursday, December  7, 2000 @ 13:38:58
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/include/catalog
     from hub.org:/home/projects/pgsql/tmp/cvs-serv92502/include/catalog

Modified Files:
    pg_proc.h

-----------------------------  Log Message  -----------------------------

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.

pgsql-committers by date:

Previous
From: tgl@postgresql.org
Date:
Subject: pgsql/src/backend/utils/adt (timestamp.c date.c)
Next
From: petere@postgresql.org
Date:
Subject: pgsql/src/makefiles (Makefile.bsdi Makefile.freebsd Makefile.netbsd Makefile.openbsd Makefile.sco)