| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Xiaobo Gu | 2011-01-27 13:27:25 | Re: Is there a way to build PostgreSQL client libraries with MinGW |
| Previous Message | lxzou | 2011-01-27 13:18:08 | BUG #5853: when the walsender cannot exit when reboot slave computer |