Hi Rudy!
>> Then I've modified the script so it looks like this:
>>
>> my $sth = $dbh->prepare( "SELECT dummy(?)"); $sth-> bind_param_array(
>> 1, [1,2,3]);
Rudy> You caould hack it by passing in a searlized copy of the array and
Rudy> let bind_param do the final quote pass.
I'm not sure how do I do that?
Rudy> Also, If you want, you can check out the current cvs version on the
Rudy> array_support branch which has support for array quoting and
Rudy> dequoting; although, you will have to use bind_param to get the
Rudy> above behaviour, so
Rudy> $sth->bind_param(":array_column", [EMAIL PROTECTED],
Rudy> {pg_type=>INT4ARRAYOID}); $sth->execute();
Rudy> I need to make a final pass at the array code (probably on either
Rudy> tue, or wed or friday) before it in production ready, but I think
Rudy> that you will be fine with the integer support as it is now.
Thanks for a quick response. Well, I also need strings (TEXT) arrays,
and I think I'd rather wait for a production-ready version. Especially,
if the array binding requires such an undocumented syntax.
If I understand correctly, this feature is not fully designed yet, therefore
I'd like to stick with a well-defined syntax or best practices (if there's
any) so next upgrades won't be painful.
--
Sincerely,
Dmitry Karasik
