On Sat, Feb 11, 2012 at 12:42, Jasen Betts ja...@xnet.co.nz wrote:
There is no need. now() is tagged as stable. it will only be executed once.
the planner will figure this out for you.
Actually that's not always true. In index condition arguments, the
expression would indeed be executed just
On 2012-01-26, David Johnston pol...@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
On 2012-01-26, David W Noon dwn...@ntlworld.com wrote:
Try using CURRENT_TIMESTAMP instead. In fact, CURRENT_TIMESTAMP is
more traditional SQL than now(). I don't have an ANSI standard handy,
so I cannot be certain when now() was added, if ever; but I have been
using CURRENT TIMESTAMP
Hi,
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
On 26 January 2012 15:37, Jon Smark jon.sm...@yahoo.com wrote:
Hi,
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 =
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jon Smark
Sent: Thursday, January 26, 2012 9:38 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Let-bindings in SQL statements
Hi,
Is it possible to do
On Thu, 26 Jan 2012 06:37:49 -0800 (PST), Jon Smark wrote about
[GENERAL] Let-bindings in SQL statements:
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
On Thu, Jan 26, 2012 at 3:37 PM, Jon Smark jon.sm...@yahoo.com wrote:
Hi,
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