cloud8421/query.sql

Created March 5, 2015 10:19

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/cloud8421/8fe7b8dc8d4eed09bb18.js"></script>
Save cloud8421/8fe7b8dc8d4eed09bb18 to your computer and use it in GitHub Desktop.

Download ZIP

yesql problematic query

Raw

SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc -> 'tags' ? 'qui';

Author

cloud8421 commented Mar 5, 2015

More info here: http://www.postgresql.org/docs/9.4/interactive/datatype-json.html

In short: the ? is a valid operator that check for the existence of the tags key with qui value in a jdoc jsonb column. When used with yesql, it gets parsed as a positional argument. Is there anything I can do to avoid that?

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