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