Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 38AB1633998 for ; Sun, 7 Jun 2009 17:09:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13016-03 for ; Sun, 7 Jun 2009 17:09:35 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by mail.postgresql.org (Postfix) with ESMTP id F111F6334EE for ; Sun, 7 Jun 2009 17:09:35 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1007) id 9BEBC75331E; Sun, 7 Jun 2009 20:09:34 +0000 (UTC) MIME-Version: 1.0 To: pgsql-committers@postgresql.org Subject: pgsql: Revert my patch of 2009-04-04 that removed contrib/intarray's X-Mailer: activitymail 1.24, http://search.cpan.org/dist/activitymail/ Content-Type: text/plain Message-Id: <20090607200934.9BEBC75331E@cvs.postgresql.org> Date: Sun, 7 Jun 2009 20:09:34 +0000 (UTC) From: tgl@postgresql.org (Tom Lane) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/96 X-Sequence-Number: 37300 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)