This kind of code perhaps should work for You SELECT *, CASE WHEN (pvc IS NULL OR pvc = '') AND (datepose < 1980) THEN '01' WHEN (pvc IS NULL OR pvc ... ... <看更多>

... <看更多>

PostgreSQL ; Update different column on condition using CASE statement ... I have a table which has different types of balance and I need to deduct ... ... <看更多>