> The reason this doesn't work is that the timestamp to date conversion
> depends on the time zone setting. In theory you should be able to avoid
> this by specifying the time zone to check the date in. I tried something
> like the following which I think should work, but doesn't:
> create idxfoo
I'm trying to create a index from a timestamp+tz field and want the index
to be date_trunc'd down to just the date
when i try to do a
create idxfoo on foo (date(footime));
i get a
ERROR: DefineIndex: index function must be marked IMMUTABLE
and it chokes on when i try to use the date_trunc()
