Re: [GENERAL] Getting total records in result set

1999-04-10 Thread Brett W. McCoy
On Sat, 10 Apr 1999, Mike Frisch wrote: > What is the easiest (and least system intensive) method of getting the > total number of records in the result set? I am presently opening the > cursor, doing a FETCH ALL, reading PQntuples(), closing the cursor, and > reopening it for the 'real' work. >

[GENERAL] Getting total records in result set

1999-04-10 Thread Mike Frisch
What is the easiest (and least system intensive) method of getting the total number of records in the result set? I am presently opening the cursor, doing a FETCH ALL, reading PQntuples(), closing the cursor, and reopening it for the 'real' work. Background: I am writing a CGI script that pagi