On Thu, Jan 26, 2012 at 3:37 PM, Jon Smark <jon(dot)smark(at)yahoo(dot)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:
> LET right_now = SELECT now () IN
> SELECT * FROM my_table WHERE right_now >= start AND ...
> In PL/pgSQL this is easy, but I wonder about SQL...
WITH param AS ( select now() as p_start, somefunc() as p_something )
SELECT * FROM param,my_table WHERE right_now >= param.p_start AND ...
In response to
pgsql-general by date
|Next:||From: Jason Long||Date: 2012-01-26 19:24:57|
|Subject: Optimizing Queries Joining Several Views|
|Previous:||From: panam||Date: 2012-01-26 17:56:33|
|Subject: Re: Best way to create unique primary keys across schemas?|