pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr

Index: c_uni_zon_var_mzon

Schema

public

Table

t_measure_mzon

Tablespace

(default)

Descriptions

the variable / zone pair is unique if the measurement date field is not filled in.

Condition for partial index

(mzon_date_measurement IS NULL)

Definition

CREATE UNIQUE INDEX c_uni_zon_var_mzon ON public.t_measure_mzon
 USING btree (mzon_zon_id, mzon_var_id)
 WHERE (mzon_date_measurement IS NULL);

COMMENT ON INDEX public.c_uni_zon_var_mzon
IS 'the variable / zone pair is unique if the measurement date field is not filled in.';

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