Skip site navigation (1) Skip section navigation (2)

Re: odbc error, operator does not exist

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "c k" <shreeseva(dot)learning(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: odbc error, operator does not exist
Date: 2008-08-24 00:21:46
Message-ID: dcc563d10808231721t233f3948sa3c3c9aef7db7a04@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Aug 23, 2008 at 12:05 PM, c k <shreeseva(dot)learning(at)gmail(dot)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?

In response to

pgsql-admin by date

Next:From: Tena SakaiDate: 2008-08-24 03:32:39
Subject: Re: restoring from dump
Previous:From: c kDate: 2008-08-23 18:05:40
Subject: odbc error, operator does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group