Re: Determing Postgres version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




> -----Original Message-----
> From: Gary Hoffman [mailto:ghoffman@xxxxxxxx]
> Sent: Tuesday, 18 December 2001 12:16 AM
> To: chriskl@xxxxxxxxxxxxxxxxxxx
> Cc: pgsql-php@xxxxxxxxxxxxxx
> 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



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux