Skip site navigation (1) Skip section navigation (2)

Re: to_date() marked stable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: to_date() marked stable?
Date: 2011-11-29 03:29:08
Message-ID: 4177.1322537348@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> I was wondering why we mark to_date() as stable and not immutable?

Do you really want to guarantee that it isn't, and never will be,
affected by timezone, datestyle, lc_time, etc?  In particular it seems
likely that somebody will eventually complain that since to_char can
output localized month/day names according to lc_time, to_date should be
able to read them.

> Are there people using to_date in indexes or partition functions where
> changing it to immutable would be useful?

By definition, there are not, and I don't recall many complaints from
people trying to.  On the other hand, if we mark it immutable and then
in future wish to go back to allowing environment dependencies, we will
have to risk breaking working applications.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2011-11-29 03:45:14
Subject: Re: to_date() marked stable?
Previous:From: Bruce MomjianDate: 2011-11-29 03:11:41
Subject: to_date() marked stable?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group