amitpatelx/test.sql

Created October 26, 2018 11:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/amitpatelx/b09eff031e682894bcbb4515ae7bd5e1.js"></script>
Save amitpatelx/b09eff031e682894bcbb4515ae7bd5e1 to your computer and use it in GitHub Desktop.

Download ZIP

check if an attribute doesn't have null

Raw

SELECT  * FROM "quarantine_codes" where (product_info->'inventory_group_attributes'->'rxcui')::text IS NOT NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment