SELECT * FROM foo OFFSET -1 LIMIT 1

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT * FROM foo OFFSET -1 LIMIT 1
Date: 2005-06-27 15:34:09
Message-ID: 1119886449.29687.3.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

is there a reason that

SELECT * FROM t1 OFFSET -1 LIMIT 1

does not return 0 rows? Accordingly

SELECT * FROM t1 OFFSET -1 LIMIT 2

should return 1 row, imo.

Markus

--
Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Riya Verghese 2005-06-27 16:15:15 ORDER records based on parameters in IN clause
Previous Message Bruce Momjian 2005-06-27 09:39:17 Re: [SQL] ARRAY() returning NULL instead of ARRAY[]