Why LIMIT and OFFSET are commutative - Mailing list pgsql-general

From Andrus
Subject Why LIMIT and OFFSET are commutative
Date
Msg-id fic6qu$sn9$1@news.hub.org
Whole thread Raw
List pgsql-general
I found that

SELECT * FROM foo
ORDER BY bar
OFFSET n
LIMIT m

and

SELECT * FROM foo
ORDER BY bar
LIMIT m
OFFSET n

produce always same results.

Why ?
OFFSET and LIMIT operations are NOT commutative in general.

Andrus.



pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: Error while compiling PostgreSQL with Java
Next
From: Peter Bauer
Date:
Subject: System Load analyze