gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
num_exists
Parameters
Name
Type
Mode
num
integer
IN
suff
text
IN
idvoie
integer
IN
Definition
BEGIN IF ( SELECT numero FROM adresse.point_adresse WHERE numero = num AND suffixe IS NOT DISTINCT FROM suff AND id_voie IS NOT DISTINCT FROM idvoie ) IS NULL THEN RETURN FALSE; ELSE RETURN TRUE; END IF; END;