Home > mailing lists

SELECT * FROM foo OFFSET -1 LIMIT 1 - Mailing list pgsql-sql

From	Markus Bertheau ☭
Subject	SELECT * FROM foo OFFSET -1 LIMIT 1
Date	June 27, 2005 15:34:27
Msg-id	1119886449.29687.3.camel@dicaprio.akademie1.de Whole thread Raw
Responses	Re: SELECT * FROM foo OFFSET -1 LIMIT 1 (Martín Marqués <martin@bugs.unl.edu.ar>)
List	pgsql-sql

Tree view

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@bluetwanger.de>

pgsql-sql by date:

From: davide
Date: 26 June 2005, 20:20:50
Subject: Re: multiple PK with a non UNIQUE field

From: Roy Souther
Date: 27 June 2005, 17:17:05
Subject: How can I simply substatue a value in a query?

SELECT * FROM foo OFFSET -1 LIMIT 1 - Mailing list pgsql-sql

Previous

Next