DBD::Pg using int2 / smallint

Lists: pgsql-general
From: Kyle <kaf(at)nwlink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DBD::Pg using int2 / smallint
Date: 2001-01-26 02:45:59
Message-ID: 14960.58599.810001.641879@ip146.usw5.rb1.bel.nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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