Re: MOVE LAST: why?

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MOVE LAST: why?
Date: 2003-01-08 10:04:49
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961F2D@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> FETCH LAST should return the last one row.
> FETCH RELATIVE m should return a row after skipping
> m rows if we follow the SQL standard and so the current
> implementation of FETCH RELATIVE is broken.

Yes, the syntax could probably be
FETCH [n] RELATIVE m
to keep the functionality to fetch n rows at once and not only one
after skipping m rows.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Clift 2003-01-08 11:21:28 Is the 7.3.1 geometry regression test supposed to pass perfectly on Solaris 8 x86?
Previous Message Ian Barwick 2003-01-08 09:53:51 Re: psql and readline