Problem with query SELECT v.value AS tvalue, left(e.date::text,4)::integer AS tyear, max(v.value::integer) over(partition by n.individualid)::integer AS maxvalue, min(v.value::integer) over(partition by n.individualid)::integer AS minvalue FROM radar.individual_value v LEFT JOIN radar.individual_name n ON v.individualid = n.namingid LEFT JOIN radar.event e ON e.id = v.eventfromid WHERE v.relationid = 123011 AND n.individualid = 1572 ORDER BY 2
ERROR: value "2943508480" is out of range for type integer