Date: Fri, 05 Nov 2004 17:54:41 +0100
From: Andras Kutrovics <n-drew@freemail.hu>
Subject: Simple SQL Question
To: pgsql-sql@postgresql.org
Message-id: <418BB051.6070808@freemail.hu>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)

Hi All!

In one of my application, I would like to implement incremental
fetching. The problem is that I would like to run it
from a stateless application server, so I have to tell where
to begin fetching data. It is simple for a table which has single column
primary key, but causes difficulties (at least for me) in
a more-column primary key..

Let say I have a table wich has the primary key: itemkey,location

table1
------
itemkey
location
...
--------


select * from table1 LIMIT x

gives me the first x row of the result.
After that, I save the last value, and next time, I adjust
the query as

select * from table1 where itemkey>:lastvalue LIMIT x

that should be enough for an 'Item' table, but I have another
column in the primary key.

let say, I have the following in Table1:

itemkey		location
------------------------
00001		00001
00001		00002
...
00005		00001
00005		00002
00005		00003 <--- lets say this is the last value

next time i want to run a query, which starts from

00005		00004
00006		00005

and so on..

How can I specify that in sql?
I dont want to use cursor:), I would like to do it in plain sql.
(It it is possible).

Thank you in advance

Andras Kutrovics