db_ofb
Previous topic Chapter index Next topic

Index: c_uni_zon_var_mzon

 

 

Schema

public

 

Table

t_mesure_mzon

 

Tablespace

(default)

 

Descriptions

le couple variable / zone est unique si le champs date de mesure est non renseigné.

 

Condition for partial index

(mzon_date_mesure IS NULL)

Definition

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

COMMENT ON INDEX public.c_uni_zon_var_mzon
IS 'le couple variable / zone est unique si le champs date de mesure est non renseigné.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic