{"action":"created","issue":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/336","labels_url":"https://api.github.com/repos/begriffs/postgrest/issues/336/labels{/name}","comments_url":"https://api.github.com/repos/begriffs/postgrest/issues/336/comments","events_url":"https://api.github.com/repos/begriffs/postgrest/issues/336/events","html_url":"https://github.com/begriffs/postgrest/issues/336","id":114383288,"number":336,"title":"Cannot filter by JSON equality","user":{"login":"begriffs","id":911911,"avatar_url":"https://avatars.githubusercontent.com/u/911911?v=3","gravatar_id":"","url":"https://api.github.com/users/begriffs","html_url":"https://github.com/begriffs","followers_url":"https://api.github.com/users/begriffs/followers","following_url":"https://api.github.com/users/begriffs/following{/other_user}","gists_url":"https://api.github.com/users/begriffs/gists{/gist_id}","starred_url":"https://api.github.com/users/begriffs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/begriffs/subscriptions","organizations_url":"https://api.github.com/users/begriffs/orgs","repos_url":"https://api.github.com/users/begriffs/repos","events_url":"https://api.github.com/users/begriffs/events{/privacy}","received_events_url":"https://api.github.com/users/begriffs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-31T02:50:26Z","updated_at":"2015-11-02T12:59:40Z","closed_at":null,"body":"e.g. `GET http://localhost:3000/json?data=eq.{\"foo\":\"bar\"}`. It returns\r\n\r\n```json\r\n{\r\n  \"hint\": \"No operator matches the given name and argument type(s). You might need to add explicit type casts.\",\r\n  \"details\": null,\r\n  \"code\": \"42883\",\r\n  \"message\": \"operator does not exist: json = unknown\"\r\n}\r\n```\r\n\r\nBug is present in 0.2.12 and 0.3 candidate. Url encoding the json does not help."},"comment":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/comments/153009986","html_url":"https://github.com/begriffs/postgrest/issues/336#issuecomment-153009986","issue_url":"https://api.github.com/repos/begriffs/postgrest/issues/336","id":153009986,"user":{"login":"ruslantalpa","id":5537246,"avatar_url":"https://avatars.githubusercontent.com/u/5537246?v=3","gravatar_id":"","url":"https://api.github.com/users/ruslantalpa","html_url":"https://github.com/ruslantalpa","followers_url":"https://api.github.com/users/ruslantalpa/followers","following_url":"https://api.github.com/users/ruslantalpa/following{/other_user}","gists_url":"https://api.github.com/users/ruslantalpa/gists{/gist_id}","starred_url":"https://api.github.com/users/ruslantalpa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruslantalpa/subscriptions","organizations_url":"https://api.github.com/users/ruslantalpa/orgs","repos_url":"https://api.github.com/users/ruslantalpa/repos","events_url":"https://api.github.com/users/ruslantalpa/events{/privacy}","received_events_url":"https://api.github.com/users/ruslantalpa/received_events","type":"User","site_admin":false},"created_at":"2015-11-02T12:59:40Z","updated_at":"2015-11-02T12:59:40Z","body":"This is a combination of a few issue, basically what is happening here is this\r\n```\r\nselect * from \"1\".complex_items where settings = '{\"a\":1}'\r\n```\r\nand it fails\r\nbut if you do\r\n```\r\nselect * from \"1\".complex_items where settings::jsonb = '{\"a\":1}'\r\n```\r\nit works.\r\n\r\nI would say it works as expected with a few mentions:\r\nThe users can check fore equality for any part inside the json with ->> and it works but not the whole json column.\r\nWhenever we return a location header where there are no keys but there is a json column, the url will not work.\r\nI would clasiffy this as low priority since there are workarounds (use jsonb instead of json, have keys on table, filter based on data within json column)"}}