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/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
