Perl DBIx::SearchBuilder and pg_atoi: zero-length string? - Mailing list pgsql-general

Hi,

I just discovered that perl module: DBIx::SearchBuilder 0.97
has a LoadByCols() method that builds a generic SELECT
query that seems to assume '' is a valid value to test on
any field.  (The code is :
------------------------------------------------------------------
sub LoadByCols  {
    my $self = shift;
    my %hash  = (@_);
    my (@bind, @phrases);
    foreach my $key (keys %hash) {
        if (defined $hash{$key} &&  $hash{$key} ne '') {
        my $op;
        my $value;
        if (ref $hash{$key} eq 'HASH') {
            $op = $hash{$key}->{operator};
            $value = $hash{$key}->{value};
       } else {
            $op = '=';
            $value = $hash{$key};
        }

                push @phrases, "$key $op ?";
                push @bind, $value;
        }
        else {
                push @phrases, "($key IS NULL OR $key = '')";
        }
    }

    my $QueryString = "SELECT  * FROM ".$self->Table." WHERE ".
    join(' AND ', @phrases) ;
    return ($self->_LoadFromSQL($QueryString, @bind));
}
-----------------------------------------------------------
)

PG 7.3.4 generates a "pg_atoi: zero-length string" error
when '' can't be coerced to the column type.  I understand
the reason for changing this behavior from 7.2...

Can anyone point me to a version of DBIx::SearchBuilder that
works with PG 7.3.4 and above?

Thanks!
Steve
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.