Re: Fixing row comparison semantics

>
>Huh?  The only "current behavior" with other operators is failure:

you didn't understand me. I know so operator <* isn't supported now.
I prefere SQL spec behave too. But what I wont:

a <* b   ~ ai <= bi and one ai < bi => true ; if one ai > bi => NULL; else 
false

but this behave is from some views really chaotic. This comparation is used 
in operation research, but propably is far to ideas ANSI SQL. It was  only 
idea.

>
>regression=# select (1,1) <* (1,2);
>ERROR:  operator <* is not supported for row expressions
>
>In any case, you can get the equivalent of the current behavior by
>writing out
>    1 <* 1 AND 1 <* 2
>so I don't see any strong need to support non-SQL-spec behaviors here.
>
>            regards, tom lane

_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/