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