Tatsuo Ishii wrote: > > > 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...
I remember the thread but didn't see a TODO in there at the time. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
