problems of comparators in Oracle

Hello,

I find that it is impossible to use >, <, => or =< to compare tuple projections greater than 1. For example, (Att1, Att2)>((1,2)). However, in the Oracle manual(v6), it states that the comparsion more than 1-arity is allowed such as (A,B)> all((1,2),(3,1)). The comparsion will do according to lexciographical ordering. Anybody can help?  

In fact it works fine for equality comparsion, say, (Att1, Att2) = ((1,2)).

Cheers,
Wilfred. Received on Tue Apr 23 1996 - 00:00:00 CEST