Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id CD7406503F4
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 23 Aug 2008 17:46:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 67755-01-4 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Sat, 23 Aug 2008 17:46:13 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.227])
	by postgresql.org (Postfix) with ESMTP id 3BD8465043D
	for <pgsql-admin@postgresql.org>; Sat, 23 Aug 2008 17:37:11 -0300 (ADT)
Received: by qb-out-0506.google.com with SMTP id d8so1490607qbc.23
	for <pgsql-admin@postgresql.org>; Sat, 23 Aug 2008 13:37:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=gcntV5v4Fmlaw7hO50VEW2UJiIjCA/cYV9kAzisy4MI=;
	b=b181SCNmMzkv9B+F6zX18GzYoqfqd/Souz+WjvSrbb37hwxOilWa2r8uuL9RRX2dZU
	LYGzV3LjJs4U94rhcGY/ilfEx10wzhyLKe2RtMpyQDZgn+GEhgzc32LrwDwLJpy6j7Pf
	oyUFDaycrT7Fv5JHdha5sXasf0UKOWfcd439U=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=dn/+OLp5Y+tVjUJIQ5qpyCW5ORJv7nUNCeVYgGqkbt2+pVO5+JT2NDE/4sYvUkLk2A
	HdEdcLhRFKh2EtOqyFlEA96ZAB9yXpvZ28lx1kBgdYm7FGmC0V0jNgisI4i6cg1eT8zz
	j/4XNR+0LxC5jOiJbIaoDdPxlssOD+F++uKg8=
Received: by 10.65.22.11 with SMTP id z11mr4173738qbi.57.1219514741096;
	Sat, 23 Aug 2008 11:05:41 -0700 (PDT)
Received: by 10.65.200.5 with HTTP; Sat, 23 Aug 2008 11:05:40 -0700 (PDT)
Message-ID: <d8e7a1e30808231105t168254bat372f1f9fb592d00@mail.gmail.com>
Date: Sat, 23 Aug 2008 23:35:40 +0530
From: "c k" <shreeseva.learning@gmail.com>
To: pgsql-admin@postgresql.org
Subject: odbc error, operator does not exist
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_39360_28688793.1219514740681"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/141
X-Sequence-Number: 29986

------=_Part_39360_28688793.1219514740681
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all,

As I am testing our old mysql based erp app., on postgresql with most of
things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and
Access 2003, I got this error:
ODBC -call failed. Operator does not exist: date < numeric;error while
executing the query. This error does not comes when we use mysql. and we are
not using any type server based views, stored procs ec. for this. This error
comes when I use a dlookup function to check whether date field is less than
a form value. It seems that this will be an ODBC driver problem to not cast
the value properly. Please give the solution and the details.
Thanks,
CPK

------=_Part_39360_28688793.1219514740681
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Hello all,<br><br>As I am testing our old mysql based erp app., on postgresql with most of things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and Access 2003, I got this error:<br>ODBC -call failed. Operator does not exist: date &lt; numeric;error while executing the query. This error does not comes when we use mysql. and we are not using any type server based views, stored procs ec. for this. This error comes when I use a dlookup function to check whether date field is less than a form value. It seems that this will be an ODBC driver problem to not cast the value properly. Please give the solution and the details.<br>
Thanks,<br>CPK<br></div>

------=_Part_39360_28688793.1219514740681--