Common mistakes in PostgreSQL

Re:Common mistakes in PostgreSQL by rb808 on Friday May 03, 2019 @11:16AM (#19819151)

> In addition, at least one country (Sweden I think), doesn't allow values like 0.01.

There are a few countries where they no longer bother with small coins to represent .01, so cash transactions are rounded to nearest .05 or similar, but the .01 is still valid for electronic transactions. I expect that is the situation in Sweden. (I wish US did this too)

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by Mister_Snuggles on Friday May 03, 2019 @03:21PM (#19821416)

Canada did this. No more $0.01 coins, $0.05 is the smallest denomination.

Electronic transactions, which account for over 50% of transactions in Canada, still use pennies though.

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by manojlds on Friday May 03, 2019 @11:18PM (#19824200)

India got rid of 0.1, 0.25 and 0.5. Cash transactions are rounded to the rupee.

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by kentosi on Friday May 03, 2019 @01:37PM (#19820451)

And Australia. We got rid of 1c and 2c coins back in the 90s.

[ Parent | on HN ]

Re:Common mistakes in PostgreSQL by axman6 on Sunday May 05, 2019 @12:58AM (#19831252)

But electronic transactions are still processed to the cent.

[ Parent | on HN ]