| Subject | Re: Making evaluation of UDFs constant across a query |
|---|---|
| Author | homerjones1941 |
| Post date | 2011-03-19T17:47:32Z |
>Can you declare a variable, and then just assign the value once? If so, you could use the value of the variable instead of running the UDF over and over.
> Is there a technique to make the return value of a UDF constant across
> the execution of a single query?
>
> For example, I'd like getExactTimestamp() -- or, rather, a UDF very
> much like it -- to return the same result every time it is evaluated...