postgresql7.1 select CASE WHEN now() < :date::timestamp THEN 1 ELSE 0 END select CASE WHEN :start_date::timestamp < :end_date::timestamp THEN 1 ELSE 0 END select CASE WHEN :start_date::timestamp < now() + :future_years THEN 1 ELSE 0 END