Re: postgres session termination - Mailing list pgsql-general

From Alban Hertroys
Subject Re: postgres session termination
Date
Msg-id 41FE4E98.8090303@magproductions.nl
Whole thread Raw
In response to Re: postgres session termination  (John DeSoi <desoi@pgedit.com>)
Responses Re: postgres session termination  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
John DeSoi wrote:
> I think there are much better ways to do this. If the result set is
> large, the user could be waiting a very long time. Two possibilities are
> (1) use a cursor or (2) use limit and offset in your select statement
> grab only the rows you need to display.

Someone correct me if I'm wrong, but I don't think PHP supports cursors
(Maybe PHP 5?).

Otherwise, that would have been a neat solution indeed.

--
Alban Hertroys
MAG Productions

T: +31(0)53 4346874
F: +31(0)53 4346876
E: alban@magproductions.nl
W: http://www.magproductions.nl

pgsql-general by date:

Previous
From: Sven Willenberger
Date:
Subject: Re: Howto determin the number of elemnts of an array
Next
From: Sven Willenberger
Date:
Subject: Dereferencing a 2-dimensional array in plpgsql