| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
| Cc: | John DeSoi <desoi(at)pgedit(dot)com>, Rick Schumeyer <rschumeyer(at)ieee(dot)org>, 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgres session termination |
| Date: | 2005-01-31 21:38:38 |
| Message-ID: | 1107207518.16640.150.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2005-01-31 at 09:28, Alban Hertroys wrote:
> 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.
PHP supports postgresql cursors, and has since php was able to connect
to postgresql.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-31 21:41:43 | Re: Dereferencing a 2-dimensional array in plpgsql |
| Previous Message | Michael Fuhr | 2005-01-31 21:32:38 | Re: table name restiction |