pggeodb-preprod.nancy.inra.fr/db_onf_gde - db_onf_gde on pggeodb-preprod.nancy.inra.fr

Function: _raster_constraint_info_index

Schema

public

Owner

postgres

Descriptions

There is no description for function _raster_constraint_info_index

Options

Definition

CREATE OR REPLACE FUNCTION public._raster_constraint_info_index (
 rastschema name,
 rasttable name,
 rastcolumn name
)
RETURNS boolean AS
$span$
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;
$span$
LANGUAGE 'sql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23