Re: Negative LIMIT and OFFSET?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Negative LIMIT and OFFSET?
Date: 2007-12-14 17:32:40
Message-ID: 20071214173240.GA11628@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2007-12-14 17:33:40 Re: Negative LIMIT and OFFSET?
Previous Message Alvaro Herrera 2007-12-14 16:21:05 [postgres@microbizz.nl: Getting multiple values from a sequence?generator]