pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedodbc error, operator does not exist
2+ messages / 2 participants
[nested] [flat]
* odbc error, operator does not exist
@ 2008-08-23 18:05 c k <shreeseva.learning@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: c k @ 2008-08-23 18:05 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: odbc error, operator does not exist
@ 2008-08-24 00:21 Scott Marlowe <scott.marlowe@gmail.com>
parent: c k <shreeseva.learning@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-08-24 00:21 UTC (permalink / raw)
To: c k <shreeseva.learning@gmail.com>; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-24 00:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-23 18:05 odbc error, operator does not exist c k <shreeseva.learning@gmail.com>
2008-08-24 00:21 ` Scott Marlowe <scott.marlowe@gmail.com>
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