Skip to content

Instantly share code, notes, and snippets.

@fogonthedowns

fogonthedowns/gist:55d7bb3a0e4f3ffaaa05a0bfefbd29f3

Created April 1, 2016 18:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save fogonthedowns/55d7bb3a0e4f3ffaaa05a0bfefbd29f3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save fogonthedowns/55d7bb3a0e4f3ffaaa05a0bfefbd29f3 to your computer and use it in GitHub Desktop.
Download ZIP
convert lbs to grams
Raw
gistfile1.txt
UPDATE inventory
SET original_amount = original_amount * 453.592,
original_units='grams'
WHERE original_units ILIKE 'lbs';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment