> > Is there a way to force PostGreSQL to use a specific data type? I tried
> > $dbh_sth{rawlist}->bind_param(2,$maxid,{TYPE=>SQL_INTEGER}) before the
> > execute, but it says that this isn't a PostGreSQL datatype, which makes no
> > sense to me!
> >
>
> Yes. $sth->bind_param(":param", $datum, SQL_INTEGER) should work. Note
> that there is no "{TYPE=>...}" Just the bare SQL_INTEGER. There is a bug
> in DBD::Pg < 1.32_1 where it would not let you specify an SQL type using
> {TYPE=>}, and thow an error stating that you cannot specify both sql type
> and pg type.
That seems to have solved it. I got the TYPE=>SQL_INTEGER example from
page 124 in the "Programming the Perl DBI" book. Is there another
resource with all these additional details somewhere?
In any case, thanks for the help. I'm sure you've saved me a lot of time!
I was just downloading the DBI source code to go fishing for the error
message.
Ian
