"paul rivers" <rivers.paul@xxxxxxxxx> writes: > But I question the original poster's report of Oracle's behavior. I don't > have 9.2.0.8 to test, but on 9.2.0.7: Er ... your example doesn't actually seem to involve greatest() or least()? regards, tom lane