Re: [BUGS] BUG #5852: Function date_trunc is not IMMUTABLE

2011-01-27 Thread Tom Lane
"Oleg" writes: > Please mark function date_trunc as IMMUTABLE for using in index. The version for timestamp without time zone already is marked immutable. The version for timestamp with time zone can't be marked immutable, because it isn't: its behavior depends on the timezone setting. Depending

Re: [BUGS] BUG #5852: Function date_trunc is not IMMUTABLE

2011-01-27 Thread hubert depesz lubaczewski
On Thu, Jan 27, 2011 at 11:02:46AM +, Oleg wrote: > > The following bug has been logged online: > > Bug reference: 5852 > Logged by: Oleg > Email address: sero...@gmail.com > PostgreSQL version: 8.3 > Operating system: CentOS > Description:Function date_trunc is n

[BUGS] BUG #5852: Function date_trunc is not IMMUTABLE

2011-01-27 Thread Oleg
The following bug has been logged online: Bug reference: 5852 Logged by: Oleg Email address: sero...@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