TODO item: immutable date_trunc with timezone arg

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: TODO item: immutable date_trunc with timezone arg
Date: 2014-07-01 03:49:43
Message-ID: 53B22FD7.4040408@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 funcs that could use TimeZone-insensitive
variants too.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip kumar 2014-07-01 03:58:23 Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Previous Message Kyotaro HORIGUCHI 2014-07-01 03:26:43 Re: Escaping from blocked send() reprised.