db_venik |
|
View: pollen04
db_venik |
|
View: pollen04
Schema
Owner
albenard
Descriptions
There is no description for view pollen04
Columns
Name | Data type | Description |
|---|---|---|
jointure_pollen |
varchar(50) |
|
nb_peres |
integer |
|
count |
bigint |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table pollen04
Definition
jointure_pollen,
nb_peres,
count)
AS
SELECT pollen.recup_pollen AS jointure_pollen,
pollen.nb_lots AS nb_peres,
count(melange_pollen.idmelange) AS count
FROM pollen,
melange_pollen
WHERE pollen.idlot_pollen = melange_pollen.idmelange
GROUP BY pollen.recup_pollen, pollen.nb_lots
ORDER BY pollen.recup_pollen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|