oppijanumerorekisteri
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
tarkistusmerkki(hetu text)
Parameters
Name
Type
Mode
hetu
text
IN
Definition
declare numerot integer; declare jakojaannos integer; BEGIN select (cast(substr(hetu,1,6) as integer)*1000 + cast(substr(hetu,8,3) as integer)) into numerot; select numerot % 31 into jakojaannos; return substr('0123456789ABCDEFHJKLMNPRSTUVWXY', jakojaannos+1,1); END