Re: Negative offsets - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Negative offsets
Date
Msg-id 20051217002656.GD53809@pervasive.com
Whole thread Raw
In response to Re: Negative offsets  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Fri, Dec 16, 2005 at 07:14:42PM -0500, Bruce Momjian wrote:
> Actually we allow negative offsets and limits.  Seems we should disallow
> them.  Yes, it would be interesting if they did offsets relative to the
> end of the result set.

Either interesting or a great way to introduce bugs... AFAIK you can
always get the same behavior just by reversing the sort order, so I'd
lean towards not allowing negative offsets.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Negative offsets
Next
From: Bruce Momjian
Date:
Subject: Re: client_encoding values