D
D
des1roer2015-09-21 07:55:56
PostgreSQL
des1roer, 2015-09-21 07:55:56

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 question

Ask a Question

731 491 924 answers to any question