4 ms·
In case people read the comments first, this is about postgres data types. It's pretty comprehensive and I especially liked the section about how datatypes are
by fyp 7y ago
In case people read the comments first, this is about postgres data types.
It's pretty comprehensive and I especially liked the section about how datatypes are implemented internally (pg 25). I wish it went into more details though.
- giornogiovanna 7y agoYes, it's a very nice overview of Postgres data types. My only question is: if the "money" type is bad, what should we use instead? The author proposed a new "currency" type, but that doesn't exist yet. OT: I initially thought that the article would be about function types, which are also called exponential types (hence the pun on "power").
- teddyh 7y agoMy current understanding is that DECIMAL (a.k.a. NUMERIC) is the recommended type for monetary values in PostgreSQL.
- toolslive 7y agomaybe it (Postgres) should be in the title so people don't need to click through only to learn they're not interested.