Src |
CREATE FUNCTION "URX_PUBLIC"."_raster_constraint_info_index"(rastschema name, rasttable name, rastcolumn name)
RETURNS boolean AS
$BODY$
SELECT
TRUE
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_index i
ON i.indexrelid = c.oid
JOIN pg_catalog.pg_class c2
ON i.indrelid = c2.oid
JOIN pg_catalog.pg_namespace n
ON n.oid = c.relnamespace
JOIN pg_am am
ON c.relam = am.oid
JOIN pg_attribute att
ON att.attrelid = c2.oid
AND pg_catalog.format_type(att.atttypid, att.atttypmod) = 'raster'
WHERE c.relkind IN ('i')
AND n.nspname = $1
AND c2.relname = $2
AND att.attname = $3
AND am.amname = 'gist'
AND strpos(pg_catalog.pg_get_expr(i.indexprs, i.indrelid), att.attname) > 0;
$BODY$
LANGUAGE 'sql' STABLESTRICT ;
|