Re: ODBC int2 parameters to pg function - Mailing list pgsql-odbc

From Gary Doades
Subject Re: ODBC int2 parameters to pg function
Date
Msg-id 4054A555.1760.4D76A1B@localhost
Whole thread Raw
In response to Re: ODBC int2 parameters to pg function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
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@gpdnet.co.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



pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: ODBC int2 parameters to pg function
Next
From: Steve Jorgensen
Date:
Subject: Some problems with Access and ODBC to PostgreSQL