value_or_raise.sql

create or replace function value_or_raise(
  anyelement,
  if boolean,
  else_raise text
)
returns anyelement
language plpgsql
immutable
as $function$

begin
    if $2 then
      return $1;
    else
      raise exception '%',$3;
    end if;
end;

$function$