> Tatsuo Ishii <t-ishii@sra.co.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
there were some concerns about backwards compatibility.
 
Merlin

Thu, 9 Sep 2004 14:06:57 -0400
"Merlin Moncure" <merlin.moncure@rcsonline.com>
Re: row wise comparison broken 
> > Tatsuo Ishii <t-ishii@sra.co.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

Fri, 10 Sep 2004 07:33:23 +0900 (JST)
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: row wise comparison broken 
Tatsuo Ishii wrote:
> > > Tatsuo Ishii <t-ishii@sra.co.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 10 Sep 2004 01:10:39 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: row wise comparison broken
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I remember the thread but didn't see a TODO in there at the time.

* Make row-wise comparisons work per SQL spec

			regards, tom lane

Fri, 10 Sep 2004 01:26:41 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: row wise comparison broken 