Re: ODBC Driver

I got this report from a user. Anyone?

---------------------------------------------------------------------------

Goertz, Dave PSC wrote:
> We have been using the old driver (ver. 07_01_0004) and its seems fine
> except for when doing left outer joins from Access. The log shows that
> characters like '{' are being placed into the code being given to the back
> end.
> We tried the newer one (ver. 07_03_0100) in the summer and found that it
> caused other problems so we stayed with the old one.
> Now we were trying the newest one (ver. 07_03_0200) and it seems to fix the
> left outer join problem but breaks other things.
> In particular we use a language called SAS to talk to PostgreSQL and
> everything works except for certain comparisons.
>
> Ex: If REG_PY NE 0;
>
> The old driver passes some 39,000 records through this statement but the new
> one passes 1900.
>
> Are data types being screwed up. REG_PY should just be a numeric datatype.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073