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

Re: [ODBC] odbc error

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: samuele(dot)brignoli(at)darpha(dot)com
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [ODBC] odbc error
Date: 2002-01-21 02:36:40
Message-ID: 3C4B7EB8.9EE2BD5D@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
I wrote:
> 
> > -----Original Message-----
> > From: Samuele Brignoli
> >
> > When trying to execute this :
> >
> > select select DOC_MAST.MVNUMREG,DOC_MAST.MVDATREG  from TESTDOC_MAST
> > DOC_MAST where DOC_MAST.MVNUMDOC = 57 AND DOC_MAST.MVSERIAL <>
> > '0000000343'
> > AND DOC_MAST.MVALFDOC = '  ' AND EXTRACT(YEAR FROM DOC_MAST.MVDATDOC) =
> > EXTRACT(YEAR FROM {d '2001-11-26'}) AND DOC_MAST.MVPRD = 'DV' AND
> > DOC_MAST.MVANNDOC = '2001'
> >
> > with psqlodbc 7.01.00.09, it sends me an error 'cause the type casting {d
> > '2001-11-26'} doesn't work.

Please try the driver at 
	http://w2422.nsk.ne.jp/~inoue/.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2002-01-23 19:10:27
Subject: Re: LWLock contention: I think I understand the problem
Previous:From: Hiroshi InoueDate: 2002-01-18 22:37:52
Subject: Re: ODBC problem

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-01-21 04:49:45
Subject: Bug #564: CREATE TABLE with long table name and long serial column name can cause conflicting sequence naming
Previous:From: Chris BainbridgeDate: 2002-01-21 01:32:49
Subject: bug in contrib-global.mk

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