Re: Negative LIMIT and OFFSET? - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Negative LIMIT and OFFSET?
Date
Msg-id 20071214173240.GA11628@crankycanuck.ca
Whole thread Raw
In response to Re: Negative LIMIT and OFFSET?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
On Fri, Dec 14, 2007 at 09:02:04AM +0000, Gregory Stark wrote:
> 
> Oh, and incidentally the problem with WARNING is that this is DML which could
> potentially be executing hundreds or thousands of times per minute. A WARNING
> is effectively an ERROR.

Good point.  Also, the sort of case where you're likely to be automatically
generating these negative values is also the sort of case where you have
various nice programmatic interfaces, many of which store up all the
warnings.  The warnings then have to be freed explicitly, which of course
means that by adding a warning, clients would suddenly start to chew through
piles of memory.

A


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: [postgres@microbizz.nl: Getting multiple values from a sequence?generator]
Next
From: Andrew Sullivan
Date:
Subject: Re: Negative LIMIT and OFFSET?