Alexander Borkowski <alexander.borkowski@abri.une.edu.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