db_venik
Previous topic Chapter index Next topic

View: pollen03

 

 

Schema

public

 

Owner

albenard

 

Descriptions

There is no description for view pollen03

 

Columns

Name

Data type

Description

jointure_pollen

varchar(50)

 

commentaires

text

 

nb_peres

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table pollen03

 

Definition

CREATE VIEW public.pollen03 (
   jointure_pollen,
   commentaires,
   nb_peres)
AS
SELECT
pollen.recup_pollen AS jointure_pollen,
   pollen.commentaire AS commentaires,
   pollen.nb_lots AS nb_peres
FROM pollen
WHERE "substring"(pollen.recup_pollen::text, 5, 1) = 'M'::text OR
   "substring"(pollen.recup_pollen::text, 5, 1) = 'R'::text
ORDER BY pollen.recup_pollen;

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