Re: Fixing row comparison semantics

>
>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/