DBD::Pg using int2 / smallint - Mailing list pgsql-general

From Kyle
Subject DBD::Pg using int2 / smallint
Date
Msg-id 14960.58599.810001.641879@ip146.usw5.rb1.bel.nwlink.com
Whole thread Raw
List pgsql-general
I need to have the perl DBI driver cast my queries to int2 / SMALLINT
for my queries to use the index in one of my tables.  I don't think
the call:

 $sth->bind_param(1, $smallint_value, SQL_SMALLINT);

seems to be doing it.  How can I accomplish this?  Or how can I verify
that the values are being passed as int2's?

Thanks,
Kyle


pgsql-general by date:

Previous
From: adb
Date:
Subject: how do I test conditions inside a stored procedure/function
Next
From: Tom Lane
Date:
Subject: Re: Performance: Unix sockets vs. TCP/IP sockets