From 6168149760f56dfaea2b140f6d2a057bc4eded99 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 22 Mar 2014 04:26:08 +0000 Subject: [PATCH] #2674 raster missing availability info for some operators and functions used in equality operator git-svn-id: http://svn.osgeo.org/postgis/trunk@12333 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in index 1a9d3b7ce..662552a7f 100644 --- a/raster/rt_pg/rtpostgis.sql.in +++ b/raster/rt_pg/rtpostgis.sql.in @@ -5622,23 +5622,27 @@ CREATE CAST (raster AS bytea) ------------------------------------------------------------------- -- call PostgreSQL's hashvarlena() function +-- Availability: 2.1.0 CREATE OR REPLACE FUNCTION raster_hash(raster) RETURNS integer AS 'hashvarlena' LANGUAGE 'internal' IMMUTABLE STRICT; -- use raster_hash() to compare +-- Availability: 2.1.0 CREATE OR REPLACE FUNCTION raster_eq(raster, raster) RETURNS bool AS $$ SELECT raster_hash($1) = raster_hash($2) $$ LANGUAGE 'sql' IMMUTABLE STRICT; +-- Availability: 2.1.0 CREATE OPERATOR = ( LEFTARG = raster, RIGHTARG = raster, PROCEDURE = raster_eq, COMMUTATOR = '=', RESTRICT = eqsel, JOIN = eqjoinsel ); +-- Availability: 2.1.0 CREATE OPERATOR CLASS hash_raster_ops DEFAULT FOR TYPE raster USING hash AS OPERATOR 1 = , -- 2.40.0