Re: DBI interaction with postgres

2011-01-04 Thread Brandon McCaig
On Tue, Jan 4, 2011 at 8:12 AM, jankes wrote: > my $nowe = $generuj->fetchrow_array; I haven't had the pleasure of using DBI yet, but CPAN says to exercise caution when using fetchrow_array in scalar context. Perhaps you should switch to list context. Either way, check the status of $generuj->err

DBI interaction with postgres

2011-01-04 Thread jankes
Hi list, My problem will be best explained with an example: my $generuj = $dbh->prepare("SELECT plpgsql_function(par1, par2, par3)"); $generuj->execute(); my $nowe = $generuj->fetchrow_array; generuj->finish(); print "$nowe\n"; Now the plpgsql_function(par1, par2, par3) does some inserts and oth