Re: Fixing row comparison semantics - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Fixing row comparison semantics
Date
Msg-id BAY20-F17C8D0B76C52988BD5636F9340@phx.gbl
Whole thread Raw
In response to Re: Fixing row comparison semantics  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Fixing row comparison semantics  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Fixing row comparison semantics  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>
>TODO updated:
>
>    * %Make row-wise comparisons work per SQL spec
>
>      Right now, '(a, b) < (1, 2)' is processed as 'a < 1 and b < 2', but
>      the SQL standard requires it to be processed as a column-by-column
>      comparison, so the proper comparison is '(a < 1) OR (a = 1 AND b < 2)'
>
>

Can we save current behave (with small modification) with other operator, 
like <*

(1,1) <* (1,2) = true
(1,2) <* (2,1) is NULL
(2,3) <* (1,2) = false

it's usefull for multicriterial optimalisation

Regards
Pavel Stehule

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Fixing row comparison semantics