Re: row wise comparison broken - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: row wise comparison broken
Date
Msg-id 20040910.073323.15268600.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: row wise comparison broken  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: row wise comparison broken
List pgsql-hackers
> > 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification of action on Delete
Next
From: Josh Berkus
Date:
Subject: Re: Supporting Encryption in Postgresql