Re: Limiting number of records to show.

Well gee, I suppose you could consider writing some sort of rewrite rule.
Why not just ask your users to not do that?

Joshua b. Jore
http://www.greentechnologist.org

On Fri, 3 May 2002, Wim wrote:

> Thanx for the fast response!
>
> Can I apply this to a user profile?
> If my users type SELECT * FROM table... they should see only 1000 records...
>
> Thanx!
>
> Duncan Adams (DNS) wrote:
>
> >u could use.
> >
> >select * from <table> limit 1000 offset 2000;
> >
> >-----Original Message-----
> >From: Wim [mailto:wdh(at)belbone(dot)be]
> >Sent: Friday, May 03, 2002 10:47 AM
> >To: pgsql-novice(at)postgresql(dot)org
> >Subject: [NOVICE] Limiting number of records to show.
> >
> >
> >Hello,
> >
> >I have a table with over 1.000.000 records. I'd like to limit the
> >maximum number of records to display, so if one my users opens the whole
> >table, he will see only for example 1000 records.
> >If I don't limit and they open the whole table, the server's CPU-load
> >raises to 150...
> >I searched the docs, but couldn't find the info....
> >
> >Is this possible? If yes, how do I do this?
> >
> >Thanx!
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> >subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >message can get through to the mailing list cleanly
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>