db_ofb
Previous topic Chapter index Next topic

Index: c_uni_sem_var_msem

 

 

Schema

public

 

Table

t_mesure_msem

 

Tablespace

(default)

 

Descriptions

Le couple variable / objet est unique si la date de mesure est non renseignée.

 

Condition for partial index

(msem_date_mesure IS NULL)

Definition

CREATE UNIQUE INDEX c_uni_sem_var_msem ON public.t_mesure_msem
 USING btree (msem_sem_id, msem_var_id)
 WHERE (msem_date_mesure IS NULL);

COMMENT ON INDEX public.c_uni_sem_var_msem
IS 'Le couple variable / objet est unique si la date de mesure est non renseignée.';

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