-- -- acs_reference__is_expired_p/1 -- create or replace function acs_reference__is_expired_p( repository_id integer ) returns bpchar as $$ DECLARE v_expiry_date acs_reference_repositories.expiry_date%TYPE; BEGIN select expiry_date into v_expiry_date from acs_reference_repositories where repository_id = is_expired_p.repository_id; if coalesce(v_expiry_date,now()+1) < now() then return 't'; else return 'f'; end if; END; $$ language plpgsql;