On 18/12/16 12:25, Bruce Momjian wrote:
On Wed, Nov 30, 2016 at 01:35:12PM -0800, John R Pierce wrote:
note, btw, TIMESTAMP WITH TIME ZONE doesn't actually store the timezone...
rather, it converts it to an internal representation of GMT, and then converts
it back to display time at the client's current (or specified) time zone.
Right, TIMESTAMP WITH TIME ZONE converts the timestamp value to the
local time zone on output. Imagine a monetary type that converted the
money amount to local currency on output --- that would be cool.
Hmm...
Would need to know the appropriate conversion rate. the 2 obvious
dates/times, on entry and now, may neither be the one wanted.
Also, often the buy/sell conversion rates are not the same!
Am sure there also other issues.
I don't think automatic conversion is as easy as you make it out to be.
Cheers,
Gavin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
