Tom, > I don't think there's any very clean way to fix this sort of problem in > general. ÂWe could make this particular example work if
Frankly, I don't think there *is* any safe way to use volatile functions in subqueries -- I certainly avoid it, except now() and random() which as discussed are special cases. Perhaps a WARNING is in order? -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend