Tom Lane schrieb am 14.04.2016 um 15:57: >> So the optimizer _should_ be smart enough to do the conversion only >> once at the beginning of the statement and then use that converted >> value during the execution of the statement without the need >> to re-evaluate it for each row. > > It's not; especially not in your originally posted case where the > up-conversion happens on the variable not the pseudo-constant. Which variable are you referring to? The original query only uses a simple between condition where the comparison value is a "constant" (the value of "now()") -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
