Re: Determing Postgres version

> -----Original Message-----
> From: Gary Hoffman [mailto:ghoffman(at)ucsd(dot)edu]
> Sent: Tuesday, 18 December 2001 12:16 AM
> To: chriskl(at)familyhealth(dot)com(dot)au
> Cc: pgsql-php(at)postgresql(dot)org
> Subject: Re: RE: [PHP] Determing Postgres version
>
>
> 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?

Not really - bit before my time!

Another thought - if the old version of postgres doesn't support LIMIT, does
it support CURSORs? If it does, you can simulate LIMIT by going:

BEGIN;
DECLARE mycursor CURSOR
FOR SELECT * FROM table;
FETCH FORWARD limit_no IN mycursor;
CLOSE mycursor;
COMMIT;

Chris