Answer the question
In order to leave comments, you need to log in
Postgres query with CASE?
how to specify in the case condition that the data should be taken for the current shift?
pseudocode
select case when date between 8 and 19 then avg(value)
when date > '20 hours' then avg(value)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question