Skip to content

Instantly share code, notes, and snippets.

@seifip

seifip/hasura-money-6.sql

Created June 3, 2020 06:49
Show Gist options
  • Save seifip/a0207e7e94b6cc42fe6761018cef4a62 to your computer and use it in GitHub Desktop.
Save seifip/a0207e7e94b6cc42fe6761018cef4a62 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hasura-money-6.sql
-- total_price | quantity
-- ::money | ::integer
-- ----------------------------
-- $3.50 | 4
SELECT price::numeric / quantity FROM items;
-- $0.87
SELECT price::numeric / quantity;
-- 0.87500000000000000000
SELECT (price::numeric / quantity)::money;
-- $0.88
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment