-- -- time_interval__eq/2 -- create or replace function time_interval__eq( integer, integer ) returns bool as $$ -- return boolean declare eq__interval_1_id alias for $1; eq__interval_2_id alias for $2; interval_1_row time_intervals%ROWTYPE; interval_2_row time_intervals%ROWTYPE; begin select * into interval_1_row from time_intervals where interval_id = eq__interval_1_id; select * into interval_2_row from time_intervals where interval_id = eq__interval_2_id; if interval_1_row.start_date = interval_2_row.start_date and interval_1_row.end_date = interval_2_row.end_date then return true; else return false; end if; end;$$ language plpgsql;