Hi Tino, On Tue, 2005-12-06 at 11:32 +0100, Tino Wildenhain wrote: > You can have a row number in postgres easily too. For example if you > just include a serial for the row number. Not if the order of things is determined runtime and not at insert time... > Cursor would work too but you would need to have a persistent connection. I just tried it: a cursor is not faster (what does not surprise me at all, as the amount of work looks the same to me) I guess there is no solution. -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@xxxxxxxxxx web: www.askesis.nl