Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au> writes:
> How about:
> select *
> from flights
> where date < cast(current_date + interval '30 days ago' as date);
This is the hard way ... you can just add/subtract a date and an
integer, instead:
... where date < (current_date - 30);
regards, tom lane