postgresql - Using price contraints or a function in Postgres for "money" type? -


i'm trying make sure sales prices in postgres database end in either .99 or .00.

if price 34.00, i'd database leave alone. if price 34.34 i'd changed 34.99.

can done entirely inside of postgres, function, or system of contraints? want make sure it's possible before start hammering away @ it.


Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

node.js - How do I prevent MongoDB replica set from querying the primary? -

python 3.x - PyQt5 - Signal : pyqtSignal no method connect -