Re: Let-bindings in SQL statements - Mailing list pgsql-general

From Jasen Betts
Subject Re: Let-bindings in SQL statements
Date
Msg-id jh5gm7$mrl$5@reversiblemaps.ath.cx
Whole thread Raw
In response to Let-bindings in SQL statements  (Jon Smark <jon.smark@yahoo.com>)
Responses Re: Let-bindings in SQL statements  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
On 2012-01-26, David Johnston <polobo@yahoo.com> 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

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: last entry per person
Next
From: Jasen Betts
Date:
Subject: Re: Defining Role Privileges