Skip site navigation (1) Skip section navigation (2)

Re: problem with using fetch and a join.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noel Faux <Noel(dot)Faux(at)med(dot)monash(dot)edu(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with using fetch and a join.
Date: 2002-12-22 04:42:43
Message-ID: 22946.1040532163@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2002-12-22 12:57:02
Subject: Re: pg_hba.conf
Previous:From: Noel FauxDate: 2002-12-21 23:50:11
Subject: Re: problem with using fetch and a join.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group