Skip site navigation (1) Skip section navigation (2)

Re: BUG #5852: Function date_trunc is not IMMUTABLE

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Oleg <serovov(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5852: Function date_trunc is not IMMUTABLE
Date: 2011-01-27 13:26:49
Message-ID: 20110127132649.GA15777@depesz.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Jan 27, 2011 at 11:02:46AM +0000, Oleg wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      5852
> Logged by:          Oleg
> Email address:      serovov(at)gmail(dot)com
> PostgreSQL version: 8.3
> Operating system:   CentOS
> Description:        Function date_trunc is not IMMUTABLE
> Details: 
> 
> Please mark function date_trunc as IMMUTABLE for using in index.

it cannot be immutable. please check explanation in here:
http://www.depesz.com/index.php/2010/09/09/why-is-my-index-not-being-used/
search for "immutable".

Best regards,

depesz

-- 
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

pgsql-bugs by date

Next:From: Xiaobo GuDate: 2011-01-27 13:27:25
Subject: Re: Is there a way to build PostgreSQL client libraries with MinGW
Previous:From: lxzouDate: 2011-01-27 13:18:08
Subject: BUG #5853: when the walsender cannot exit when reboot slave computer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group