db_toff on pggeodb.nancy.inra.fr |
|
View: v_tree_traits_selection
db_toff on pggeodb.nancy.inra.fr |
|
View: v_tree_traits_selection
Schema
Owner
postgres
Descriptions
View to produce recursively the trait tree according to a particular filter /vue permettant de créer récursivement l'arbre des traits selon un filtre donné
Fields
Name | Data type | Description |
|---|---|---|
descriptionfamily |
varchar(64) |
|
path |
text |
|
tra_name |
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
descriptionfamily,
path,
tra_name,
tra_id)
AS
SELECT v_tree_families_traits.description AS descriptionfamily,
v_tree_families_traits.path,
tr_trait_tra.tra_name,
tr_trait_tra.tra_id
FROM v_tree_families_traits
JOIN tr_trait_tra ON v_tree_families_traits.id_family = tr_trait_tra.tra_fam_id
WHERE v_tree_families_traits.path = 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_families_traits.path, tr_trait_tra.tra_name;
COMMENT ON VIEW public.v_tree_traits_selection
IS 'View to produce recursively the trait tree according to a particular filter /vue permettant de créer récursivement l''arbre des traits selon un filtre donné';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|