Re: row wise comparison broken

Tatsuo Ishii wrote:
> > > Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> > > > I guess this means that PostgreSQL does not fully support SQL's
> > > > row-wise comparison. We need to add this to the TODO list?
> > >
> > > I thought it was there already ... certainly this has been discussed
> > > before ...
> >
> > This was discussed (including a possible implementation of the correct
> > behavior) at some length on the performance list a little over a month
> > ago. I don't think it made it to Bruce who probably would have added to
> > the todo list...the consensus was the current behavior is wrong but
>
>
> Yes, I found the following thread started by you in the
> pgsql-performance list:
>
> Subject: [PERFORM] best way to fetch next/prev record based on index
> Date: Tue, 27 Jul 2004 06:18:43 -0700
>
> > there were some concerns about backwards compatibility.
>
> IMO 8.0 is a good chance to fix it. Maybe we could add a GUC switch to
> fall back to pre-8.0 behavior...

I remember the thread but didn't see a TODO in there at the time.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073