Re: Errors with nulls thru ODBC

> Johann Zuschlag wrote:
>
> Hi,
>
> I found a funny behavior using psqlodbc (07.01.0009) with PostgeSQL
> 7.1.3. An application shows eratic results in columns with smallint
> and int when there is no value defined, i.e. null, unknown. Sometimes
> I get a 1, 3, 5, 0, or nothing (smallint).
>
> The app is just doing a simple SELECT. There is no =null or similiar.
> I went thru all mails concerning null, isnull etc. I guess the problem
> is with the driver, not with postgreSQL. If I compare the same app
> with MSSQL I get the correct results, i.e. nothing. ;-)

Could you send me the Mylog output ?

regards,
Hiroshi Inoue