Re: Negative offsets

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: CSN <cool_screen_name90001(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Negative offsets
Date: 2005-12-17 00:26:56
Message-ID: 20051217002656.GD53809@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-12-17 00:27:53 Re: client_encoding values
Previous Message Jim C. Nasby 2005-12-17 00:16:01 Re: Versioning Schema/Stored Procedures