Re: MOVE LAST: why? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: MOVE LAST: why?
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961F2D@m0114.s-mxs.net
Whole thread Raw
In response to MOVE LAST: why?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Ian Barwick
Date:
Subject: Re: psql and readline
Next
From: Justin Clift
Date:
Subject: Is the 7.3.1 geometry regression test supposed to pass perfectly on Solaris 8 x86?