X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2912ED82E2
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  3 Nov 2005 12:17:53 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 56630-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  3 Nov 2005 16:17:51 +0000 (GMT)
Received: from CORREO.correolux.com.mx
	(customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218])
	by svr1.postgresql.org (Postfix) with ESMTP id 28B91D7AAE
	for <pgsql-sql@postgresql.org>; Thu,  3 Nov 2005 12:17:50 -0400 (AST)
Received: from 192.168.7.58 ([192.168.7.58]) by correolux.com.mx with
	MailEnable ESMTP; Thu, 03 Nov 2005 10:14:16 -0600
Subject: date question
From: Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary="=-GKoD8f6BixYxl9YHa65w"
Date: Thu, 03 Nov 2005 10:17:52 -0600
Message-Id: <1131034672.3600.74.camel@Desarrollo>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 (2.0.2-3) 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.033 required=5 tests=[AWL=0.032,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.033
X-Spam-Level: 
X-Archive-Number: 200511/44
X-Sequence-Number: 23296


--=-GKoD8f6BixYxl9YHa65w
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi everybody, in Postgres 7.0.2 I have the next query:

SELECT * from clientes_proceso where fecha_mod::date <= now() -1;

but in version 8.0.1 returns the next error:

ERROR: The operator doesn't exist: timestamp with time zone - integer

How can drop a day to now()??

--=-GKoD8f6BixYxl9YHa65w
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Hi everybody, in Postgres 7.0.2 I have the next query:<BR>
<BR>
SELECT * from clientes_proceso where fecha_mod::date &lt;= now() -1;<BR>
<BR>
but in version 8.0.1 returns the next error:<BR>
<BR>
ERROR: The operator doesn't exist: timestamp with time zone - integer<BR>
<BR>
How can drop a day to now()??
</BODY>
</HTML>

--=-GKoD8f6BixYxl9YHa65w--