CREATE or REPLACE FUNCTION  get_contact_cidnum(varchar) RETURNS varchar AS
'select cidnum from contact where id = $1;
' LANGUAGE SQL;

CREATE or REPLACE FUNCTION  set_contact_cidnum(varchar,varchar) RETURNS integer AS
'update contact set cidnum = $2 where id = $1;
 select 0 as result;
' LANGUAGE SQL;

