Re: [SQL] perl and postgres. . . - Mailing list pgsql-interfaces

From Gene Selkov Jr.
Subject Re: [SQL] perl and postgres. . .
Date
Msg-id 199904211602.LAA10273@antares.mcs.anl.gov
Whole thread Raw
In response to perl and postgres. . .  (JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>)
List pgsql-interfaces
> I'm trying in perl to get a maximum value from a field in a postgres table:
> $query="select max(userseq) from dataentry;";
> $result=$conn->exec("$query");
>
> and then capture that value in a scalar variable:
>     $userseq=($result);
>
> but it's not working.

$result->getvalue(0, 0)

(pse. read examples in `perldoc Pg`)

pgsql-interfaces by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [INTERFACES] Possible error in libpg++ interface, date[time] fields.
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [SQL] perl and postgres. . .