X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id A5D85D1B4A1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 21:52:04 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 23621-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  9 Dec 2003 17:51:35 -0400 (AST)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP id CDA44D1B4AE
	for <pgsql-sql@postgresql.org>; Tue,  9 Dec 2003 17:51:32 -0400 (AST)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 8A19C35613; Tue,  9 Dec 2003 13:51:19 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 889B5355FF; Tue,  9 Dec 2003 13:51:19 -0800 (PST)
Date: Tue, 9 Dec 2003 13:51:19 -0800 (PST)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: Re: Values like ''
In-Reply-To: <A799F7647794D311924A005004ACEA970D209757@cprodamibs249.prodam>
Message-ID: <20031209134923.D66223@megazone.bigpanda.com>
References: <A799F7647794D311924A005004ACEA970D209757@cprodamibs249.prodam>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200312/75
X-Sequence-Number: 16241

On Fri, 5 Dec 2003, Elielson Fontanezi wrote:

>   AND cronograma_evento.cd_local = ''

Is cd_local an integer type?  If so, '' no longer works as an integer
(IIRC it used to mean 0).  The exact error message and possibly schema
information would be useful if that's not what's going on.