> > Tatsuo Ishii <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]