From: Scott Marlowe <scott.marlowe@gmail.com>
To: c k <shreeseva.learning@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: odbc error, operator does not exist
Date: Sat, 23 Aug 2008 18:21:46 -0600
Message-ID: <dcc563d10808231721t233f3948sa3c3c9aef7db7a04@mail.gmail.com> (raw)
In-Reply-To: <d8e7a1e30808231105t168254bat372f1f9fb592d00@mail.gmail.com>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, shreeseva.learning@gmail.com
Subject: Re: odbc error, operator does not exist
In-Reply-To: <dcc563d10808231721t233f3948sa3c3c9aef7db7a04@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox