Re: [HACKERS] TODO item: immutable date_trunc with timezone arg

2014-07-01 Thread Craig Ringer
On 07/02/2014 11:10 AM, Noah Misch wrote: > On Tue, Jul 01, 2014 at 11:49:43AM +0800, Craig Ringer wrote: >> Currently it's unsafe/not possible to use some funtions, like >> date_trunc, in immutable functions and expression indexes. >> >> It'd be really useful to have an immutable version that took

Re: [HACKERS] TODO item: immutable date_trunc with timezone arg

2014-07-01 Thread Noah Misch
On Tue, Jul 01, 2014 at 11:49:43AM +0800, Craig Ringer wrote: > Currently it's unsafe/not possible to use some funtions, like > date_trunc, in immutable functions and expression indexes. > > It'd be really useful to have an immutable version that took the > timezone as an argument. Maybe this is a

[HACKERS] TODO item: immutable date_trunc with timezone arg

2014-06-30 Thread Craig Ringer
Currently it's unsafe/not possible to use some funtions, like date_trunc, in immutable functions and expression indexes. It'd be really useful to have an immutable version that took the timezone as an argument. Maybe this is a worthwhile beginner TODO item for the wiki? I'm sure there are other f