DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=QXdtsTsb+pZ1T6a90ttYqn8c07zm1wQLlNgyMPI1lvuM+zJzJG4/Fnm/K/njUI//tY
	nLWY7VccUljwptuCriJVIXT5ltubjeZhAG9kVzXyqzkvsgl4rpUPxuNV0IU1/HVzz1+w
	+63usYCzWe05uwx4OywJOAY3y0kwY/UR4aJ3Y=
Message-ID: <dcc563d10808231721t233f3948sa3c3c9aef7db7a04@mail.gmail.com>
Date: Sat, 23 Aug 2008 18:21:46 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "c k" <shreeseva.learning@gmail.com>
Subject: Re: odbc error, operator does not exist
Cc: pgsql-admin@postgresql.org
In-Reply-To: <d8e7a1e30808231105t168254bat372f1f9fb592d00@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <d8e7a1e30808231105t168254bat372f1f9fb592d00@mail.gmail.com>

On Sat, Aug 23, 2008 at 12:05 PM, c k <shreeseva.learning@gmail.com> wrote:
> 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.

How are we supposed to compare a date to a numeric?  What does

'2008-08-23 12:45:34' < 1000000

mean?