Home > mailing lists

LIMIT + OFFSET - Mailing list pgsql-general

From	MG
Subject	LIMIT + OFFSET
Date	January 17, 2006 14:42:57
Msg-id	000801c61b7c$c7b217f0$340aa8c0@geisslinger Whole thread Raw
Responses	Re: LIMIT + OFFSET
List	pgsql-general

Hello,

I want to show an overview where you can place 16 data sets.

I use the sql-statement

SELECT F1,F2 FROM testtable limit 16 offset 0

To show different pages I vary the value for offset.

But if I want to stay on a special data set, I have the problem to find the right value for offset.

How can I realize this?

Thanks for your help

Michaela

From: Tom Lane
Date: 17 January 2006, 14:31:12
Subject: Re: Strange error while executing query from front end:

From: "A. Kretschmer"
Date: 17 January 2006, 14:55:13
Subject: Re: LIMIT + OFFSET