Re: DATE field subtraction

Ralph Graulich wrote:
> SELECT [...]
> FROM table
> WHERE datefield >= '2002-08-19' - interval '4 weeks'

There are probably shorter forms, but the full version would be:
  '2002-08-19'::date - '4 weeks'::interval
--
Peter Gibbs
EmKel Systems