--
-- 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;