db_venik |
|
View: geno_sans_graines4
db_venik |
|
View: geno_sans_graines4
Schema
Owner
albenard
Descriptions
There is no description for view geno_sans_graines4
Columns
Name | Data type | Description |
|---|---|---|
idgeno |
integer |
|
idespece |
integer |
|
nom_court |
varchar(30) |
|
type_geno |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table geno_sans_graines4
Definition
idgeno,
idespece,
nom_court,
type_geno)
AS
SELECT genotype.idgeno,
genotype.idespece,
genotype.nom_court,
genotype.type_geno
FROM genotype
WHERE genotype.idespece = 45 AND genotype.type_geno = 200
EXCEPT
SELECT genotype.idgeno,
genotype.idespece,
genotype.nom_court,
genotype.type_geno
FROM genotype,
graine
WHERE genotype.idgeno = graine.idgeno_gr AND graine.nb_lots > 1;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|