At 11:03 AM 2/7/00 -0500, Tom Lane wrote:
>Could be. How about cases like
>
> select distinct x,y+1 from foo order by x+y+1;
SQL> select distinct x,y+1 from foo order by x+y+1
*
ERROR at line 1:
ORA-01791: not a SELECTed expression
>> At least, the rule is simple if you can compare expression trees.
>I think we have something pretty similar for GROUP BY, actually,
>so it may not be hard to make this work.
Actually, yes, you're probably right...
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.