"paul rivers" <rivers(dot)paul(at)gmail(dot)com> 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