| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | SriRaghu Sai Kasyap <skasyap(at)opentext(dot)com> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Siva Phani Kumar Kothuri <skothuri(at)opentext(dot)com> |
| Subject: | Re: Invalid precision for money datatype |
| Date: | 2018-05-08 12:19:17 |
| Message-ID: | CAKFQuwYtJe+fZjR+mP_KsT4nJB5yYYPAisfQ28e7Pt-oFA=_PA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tuesday, May 8, 2018, SriRaghu Sai Kasyap <skasyap(at)opentext(dot)com> wrote:
>
>
> 1. How to get the locale for the money datatype column?
> 2. How to get the precision and scale for the column given a locale?
>
> As far as I know individual columns don't have locales. As for the money
type, the stored value is strictly the number value. It is, for all
intents and purposes, a numeric field with a more liberal input/constructor
function.
You can inspect the locale information for the database (session?) though
I'm not exactly sure how or how to change it. The documentation should
cover this though.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2018-05-08 13:07:48 | Re: Invalid precision for money datatype |
| Previous Message | SriRaghu Sai Kasyap | 2018-05-08 09:22:52 | Invalid precision for money datatype |