Re: ODBC int2 parameters to pg function

Thanks Tom,

I did actually put the parameter binding examples in my original post,
but as they are in .NET speak it may not have been obvious.

I guess I should try to get this on the "things to do with the ODBC"
driver list. I should be able to look at the code myself, but I will have to
remember how to speak C.

Thanks again,
Gary.

On 14 Mar 2004 at 13:24, Tom Lane wrote:

> "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk> writes:
> > AFAICS it is only int2 types that are not typecast. All other
> > datatypes (except string and int4 which don't need it) are typecast
> > explicitly by the driver before being passed to the server.
>
> I see. AFAIR you hadn't mentioned that you were declaring the parameter
> as smallint to ODBC. I tend to agree that a cast should be added in
> that case. It's not my code though ...
>
> regards, tom lane