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

odbc error

From: "Samuele Brignoli" <samuele(dot)brignoli(at)darpha(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: odbc error
Date: 2002-01-18 11:45:19
Message-ID: CNEDLAJNHCDEGDBGOHHCMEJECJAA.samuele.brignoli@darpha.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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.



Responses

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2002-01-18 18:12:19
Subject: Re: Rep:Re: Error Writing/Reading Encrypted Values
Previous:From: Cedar CoxDate: 2002-01-18 10:27:16
Subject: Re: Rep:Re: Error Writing/Reading Encrypted Values

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-18 14:59:07
Subject: Re: libpq not reentrant
Previous:From: Federico Di GregorioDate: 2002-01-18 09:28:54
Subject: libpq not reentrant

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