Re: [GENERAL] About the MONEY type - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] About the MONEY type
Date
Msg-id 20161217232556.GA19811@momjian.us
Whole thread Raw
In response to Re: About the MONEY type  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-general by date:

Previous
From: guyren@gmail.com
Date:
Subject: [GENERAL] Love Your Database: Simple Validations
Next
From:
Date:
Subject: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10