> -----Original Message-----
> From: Gary Hoffman [mailto:ghoffman@ucsd.edu]
> Sent: Tuesday, 18 December 2001 12:16 AM
> To: chriskl@familyhealth.com.au
> Cc: pgsql-php@postgresql.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
