Re: row wise comparison broken

> > 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...
--
Tatsuo Ishii