pggeodb.nancy.inra.fr/db_toff - db_toff on pggeodb.nancy.inra.fr |
|
View: v_tree_traits_selection
pggeodb.nancy.inra.fr/db_toff - db_toff on pggeodb.nancy.inra.fr |
|
View: v_tree_traits_selection
Schema
Owner
albenard
Descriptions
vue permettant de créer récursivement l'arbre des traits selon un filtre spécifique
Fields
Name | Data type | Description |
|---|---|---|
libellefamille |
varchar(64) |
|
chemin |
text |
|
tra_nom |
varchar(80) |
|
tra_id |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_tree_traits_selection
Definition
libellefamille,
chemin,
tra_nom,
tra_id)
AS
SELECT v_tree_familles_traits.libelle AS libellefamille,
v_tree_familles_traits.chemin,
tr_trait_tra.tra_nom,
tr_trait_tra.tra_id
FROM v_tree_familles_traits
JOIN tr_trait_tra ON v_tree_familles_traits.id_famille = tr_trait_tra.tra_fam_id
WHERE v_tree_familles_traits.chemin = ANY
(ARRAY['BEHAVIOUR/Nutrition behaviour/Diet'::text, 'BEHAVIOUR/Nutrition behaviour/Foraging/General characteristic'::text, 'BEHAVIOUR/Nutrition behaviour/Foraging/Hunting strategy'::text, 'BEHAVIOUR/Nutrition behaviour/Prey eaten'::text, 'BEHAVIOUR/Protection behaviour/Antipredator behaviour'::text, 'PHENOLOGY/Activity period'::text])
ORDER BY v_tree_familles_traits.chemin, tr_trait_tra.tra_nom;
COMMENT ON VIEW public.v_tree_traits_selection
IS 'vue permettant de créer récursivement l''arbre des traits selon un filtre spécifique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|