Posts by ramoncs11 • 43 points

• 2

  votes

  2

  answers

  135

  views

  A: How do I sum up the 2-interval difference in Postgresql?

  I managed to solve the problem. Basically, the conditions go within the sum(). CREATE OR REPLACE FUNCTION total_paused_time (v_id Integer) RETURNS Interval as $$ select sum( case when end_date =…

  sql postgresql

  answered 9 years, 10 months ago ramoncs11 43

• 2

  votes

  2

  answers

  135

  views

  Q: How do I sum up the 2-interval difference in Postgresql?

  I need to sum up all the gap differences that meet the Where condition. There is only one however, if there is no end_date on this line, I need to take the current time and do the calculation with…

  sql postgresql

  asked 9 years, 10 months ago ramoncs11 43