Noel Faux <Noel(dot)Faux(at)med(dot)monash(dot)edu(dot)au> writes:
> Many thanks for the tip. Yes adding the order by (id) to the statement
> allowed the FETCH BACKWARD to work. Is there any reason why the FETCH
> BACKWARD statement for such a join not to be supported in the future?
If someone wants to make it happen ... my take is that actually making
it work in all cases would be lots more trouble than it's worth. I'd
settle for producing an error message in place of a wrong answer.
regards, tom lane