Re: [HACKERS] What about LIMIT in SELECT ?

From: Terry Mackintosh <terry(at)terrym(dot)com>
To: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] What about LIMIT in SELECT ?
Date: 1998-10-14 17:45:40
Message-ID: Pine.LNX.3.95.981014134240.14397E-100000@terry1.acun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On Tue, 13 Oct 1998, Bruce Momjian wrote:

> My guess in a web application is that the transaction is started for
> every new page, so you can't have transactions spanning SQL sessions.
>
> LIMIT theoretically would allow you to start up where you left off.

************ EXACTLY !-)
Plus, it could also be used to limit bogus-run-away queries.

Terry Mackintosh <terry(at)terrym(dot)com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Taral 1998-10-14 17:56:00 RE: [HACKERS] What about LIMIT in SELECT ?
Previous Message Terry Mackintosh 1998-10-14 17:41:24 Re: [HACKERS] What about LIMIT in SELECT ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Taral 1998-10-14 17:56:00 RE: [HACKERS] What about LIMIT in SELECT ?
Previous Message Terry Mackintosh 1998-10-14 17:41:24 Re: [HACKERS] What about LIMIT in SELECT ?