pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Index: c_uni_obj_var_mobj

 

 

Schema

public

 

Table

t_measure_mobj

 

Tablespace

(default)

 

Descriptions

The variable / object pair is unique if the measure date is not entered.

 

Condition for partial index

(mobj_date_measure IS NULL)

Definition

CREATE UNIQUE INDEX c_uni_obj_var_mobj ON public.t_measure_mobj
 USING btree (mobj_obj_id, mobj_var_id)
 WHERE (mobj_date_measure IS NULL);

COMMENT ON INDEX public.c_uni_obj_var_mobj
IS 'The variable / object pair is unique if the measure date is not entered.';

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