Re: SELECT * FROM foo OFFSET -1 LIMIT 1

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT * FROM foo OFFSET -1 LIMIT 1
Date: 2005-06-27 19:35:59
Message-ID: 87ekan1tk0.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Markus Bertheau <twanger(at)bluetwanger(dot)de> writes:

> Offset for negative numbers means 0, as it seems. I think there is a
> sensible meaning for negative offset numbers and wondered, what
> arguments led to negative offsets being processed as 0 offset.

Frankly I'm surprised it's not a syntax error.

--
greg

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-06-27 20:35:12 Re: pg_attribute.attlen -1 for varchar e pbchar fields
Previous Message Markus Bertheau 2005-06-27 18:41:37 Re: SELECT * FROM foo OFFSET -1 LIMIT 1