UNION types text and bigint cannot be matched
I'm running a complex stored procedure and I'm getting an error when I have 3 unions, but with 2 unions no error. If I remove either of the top two unions it runs fine. If I make one of the NULLs a 0, it runs fine. The error is "UNION types text and bigint cannot be matched" ```lang-sql SELECT NULL AS total_time_spent FROM tbl1 GROUP BY student_id UNION ALL
postgresql