> preferably I would see extract( epoch from timestamp ) to be really > immutable, i.e. (in my opinion) it should treat incoming data as UTC > - for epoch calculation. > Alternatively - perhaps epoch extraction should be moved to specialized > function, which would have swapped mutability:
We can't have functions which are immutable or not depending on their inputs. That way lies madness. > get_epoch(timestamptz) would be immutable > while > get_epoch(timestamp) would be stable Well, to_epoch, in order to be consistent with other conversion functions. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers