Received: from antares.mcs.anl.gov (mcs.anl.gov [140.221.9.6])
	by hub.org (8.9.3/8.9.1) with SMTP id MAA80267
	for <pgsql-interfaces@hub.org>; Wed, 21 Apr 1999 12:02:25 -0400 (EDT)
	(envelope-from selkovjr@xnet.com)
Received: from xnet.com (selkovjr@selkovjr.xnet.com [205.243.141.67]) by
	antares.mcs.anl.gov (8.6.10/8.6.10) with ESMTP
	id LAA10273; Wed, 21 Apr 1999 11:02:14 -0500
Message-Id: <199904211602.LAA10273@antares.mcs.anl.gov>
To: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>, pgsql-interfaces@hub.org
Subject: Re: [SQL] perl and postgres. . . 
In-Reply-To: Your message of "Wed, 21 Apr 1999 11:45:32 EDT."
	<01BE8BEC.76C02840.jt-kirkpatrick@mpsllc.com>
Date: Wed, 21 Apr 1999 11:02:08 -0400
From: "Gene Selkov Jr." <selkovjr@xnet.com>

> 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`)