* Stephan Szabo ([EMAIL PROTECTED]) wrote: > On Mon, 6 Dec 2004, Per Jensen wrote: > > select count(*) > > from accesslog > > where time between (timeofday()::timestamp - INTERVAL '30 d') and > > timeofday()::timestamp; > > Besides the type issue, timeofday() is volatile and thus is not allowed to > be turned into a constant in order to do an index scan because it's > allowed to return different values for every row of the input.
Is there a way to say "just take the value of this function at the start
of the transaction and then have it be constant" in a query?
Stephen
signature.asc
Description: Digital signature
