date question - Mailing list pgsql-sql

From Judith Altamirano Figueroa
Subject date question
Date
Msg-id 1131034672.3600.74.camel@Desarrollo
Whole thread Raw
Responses Re: date question
Re: date question
List pgsql-sql
Hi everybody, in Postgres 7.0.2 I have the next query:<br /><br /> SELECT * from clientes_proceso where
fecha_mod::date<= now() -1;<br /><br /> but in version 8.0.1 returns the next error:<br /><br /> ERROR: The operator
doesn'texist: timestamp with time zone - integer<br /><br /> How can drop a day to now()??  

pgsql-sql by date:

Previous
From: Don Drake
Date:
Subject: Encoding on 8.0.4
Next
From: lucas@presserv.org
Date:
Subject: Re: date question