Re: odbc error, operator does not exist

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?