Can This be done - Mailing list pgsql-general

From Uros Gruber
Subject Can This be done
Date
Msg-id 10013514823.20020512222245@sir-mag.com
Whole thread Raw
Responses Re: Can This be done
List pgsql-general
Hi!

Is it possible for example I have one db with 100.000
entries. I select some data, let say about 1.000. Now i want
this data show on page by pages.

I use limit and ofset for this. But how can i know how much
is all the records. Because i want to print also how many
hits were but i don't want get all the rows at once.

Is there any function for this or i have to make 2 queries.
--
tia,
 Uros


pgsql-general by date:

Previous
From: "murphy pope"
Date:
Subject: Why is ALLOW_ABSOLUTE_DBPATHS unsafe?
Next
From: Paul M Foster
Date:
Subject: Chatter in C++ interface