Re: Determing Postgres version

On Mon, 17 Dec 2001, Gary Hoffman wrote:

> Well, I thought of that.
>
> Here's what I get:
> ERROR: function version() does not exist
>
> Any other ideas, short of actually asking the ISP help desk?

I just did it and it worked fine:

$query = "select version()";

$res = pg_exec($conn,$query);
if(!$res) {
die("not found");
}

if(($x = pg_numrows($res)) < 1) {
echo("not found in database\n");
exit;
}

$row = pg_fetch_row($res,$ii);
echo("version: $row[0]");

and it gives:

version: PostgreSQL 7.1.2 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2

Maybe it's really old?

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================