Re: BUG #5852: Function date_trunc is not IMMUTABLE

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@gmail.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@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007