Re: Let-bindings in SQL statements

On 2012-01-26, David Johnston  wrote:

> Is it possible to do the equivalent of let-bindings in a pure SQL function?
> I have a SELECT that invokes "now" multiple times.  It would be nicer to do
> it only once and reuse the value.  Something like this:

There is no need. now() is tagged as stable. it will only be executed once.

the planner will figure this out for you.

-- 
⚂⚃ 100% natural