oppijanumerorekisteri
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
check_hetu(hetu text)
Parameters
Name
Type
Mode
hetu
text
IN
Definition
BEGIN IF hetu ~* '^\d{6}[A\+\-]\d{3}[0123456789ABCDEFHJKLMNPRSTUVWXY]$' THEN if ( substr(hetu, 11, 1) like tarkistusmerkki(hetu) ) THEN return true; ELSE return false; END IF; ELSE return false; END IF; END