Обсуждение: pgsql: Revert my patch of 2009-04-04 that removed contrib/intarray's

Поиск
Список
Период
Сортировка

pgsql: Revert my patch of 2009-04-04 that removed contrib/intarray's

От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
Revert my patch of 2009-04-04 that removed contrib/intarray's definitions of
the <@ and @> operators.  These are not in fact equivalent to the built-in
anyarray operators of the same names, because they have different behavior for
empty arrays, namely they don't think empty arrays are contained in anything.
That is mathematically wrong, no doubt, but until we can persuade GIN indexes
to implement the mathematical definition we should probably not change this.
Another reason for not changing it now is that we can't yet ensure the
opclasses will be updated correctly in a dump-and-reload upgrade.  Per
recent discussions.

Modified Files:
--------------
    pgsql/contrib/intarray:
        _int.sql.in (r1.30 -> r1.31)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int.sql.in?r1=1.30&r2=1.31)
        uninstall__int.sql (r1.11 -> r1.12)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/uninstall__int.sql?r1=1.11&r2=1.12)
    pgsql/doc/src/sgml:
        intarray.sgml (r1.7 -> r1.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/intarray.sgml?r1=1.7&r2=1.8)
        release-8.4.sgml (r1.7 -> r1.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release-8.4.sgml?r1=1.7&r2=1.8)