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@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.