DBD::Pg using int2 / smallint

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
Thread:
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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-26 03:13:29 Re: beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]
Previous Message Josh Rovero 2001-01-26 01:12:35 Re: Wild Cards