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: [email protected] > 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: [email protected] / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
