{"action":"created","issue":{"url":"https://api.github.com/repos/MagicStack/asyncpg/issues/94","repository_url":"https://api.github.com/repos/MagicStack/asyncpg","labels_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/94/labels{/name}","comments_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/94/comments","events_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/94/events","html_url":"https://github.com/MagicStack/asyncpg/issues/94","id":216778007,"number":94,"title":"Passing a list as parameter","user":{"login":"juntatalor","id":8134632,"avatar_url":"https://avatars0.githubusercontent.com/u/8134632?v=3","gravatar_id":"","url":"https://api.github.com/users/juntatalor","html_url":"https://github.com/juntatalor","followers_url":"https://api.github.com/users/juntatalor/followers","following_url":"https://api.github.com/users/juntatalor/following{/other_user}","gists_url":"https://api.github.com/users/juntatalor/gists{/gist_id}","starred_url":"https://api.github.com/users/juntatalor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juntatalor/subscriptions","organizations_url":"https://api.github.com/users/juntatalor/orgs","repos_url":"https://api.github.com/users/juntatalor/repos","events_url":"https://api.github.com/users/juntatalor/events{/privacy}","received_events_url":"https://api.github.com/users/juntatalor/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-03-24T12:57:41Z","updated_at":"2017-03-24T13:24:58Z","closed_at":null,"body":"* **asyncpg version**: 0.9.0\r\n* **PostgreSQL version**: 9.6\r\n* **Python version**: 3.5\r\n* **Platform**: MacOS\r\n* **Do you use pgbouncer?**: No\r\n* **Did you install asyncpg with pip?**: Yes\r\n* **If you built asyncpg locally, which version of Cython did you use?**: -\r\n* **Can the issue be reproduced under both asyncio and\r\n  [uvloop](https://github.com/magicstack/uvloop)?**: Yes\r\n\r\nI perform SQL query with where ... in clause and can not find a way to pass a list parameter:\r\n`results = await connection.fetch('SELECT * FROM post WHERE id in ($1)', [1, 2, 3])`\r\nI always get \r\n`TypeError: an integer is required (got type list)`\r\nIs it possible to pass a list parameter to query?"},"comment":{"url":"https://api.github.com/repos/MagicStack/asyncpg/issues/comments/289021518","html_url":"https://github.com/MagicStack/asyncpg/issues/94#issuecomment-289021518","issue_url":"https://api.github.com/repos/MagicStack/asyncpg/issues/94","id":289021518,"user":{"login":"elprans","id":347119,"avatar_url":"https://avatars2.githubusercontent.com/u/347119?v=3","gravatar_id":"","url":"https://api.github.com/users/elprans","html_url":"https://github.com/elprans","followers_url":"https://api.github.com/users/elprans/followers","following_url":"https://api.github.com/users/elprans/following{/other_user}","gists_url":"https://api.github.com/users/elprans/gists{/gist_id}","starred_url":"https://api.github.com/users/elprans/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elprans/subscriptions","organizations_url":"https://api.github.com/users/elprans/orgs","repos_url":"https://api.github.com/users/elprans/repos","events_url":"https://api.github.com/users/elprans/events{/privacy}","received_events_url":"https://api.github.com/users/elprans/received_events","type":"User","site_admin":false},"created_at":"2017-03-24T13:24:58Z","updated_at":"2017-03-24T13:24:58Z","body":"try\r\n```python\r\n\r\nresults = await connection.fetch('SELECT * FROM post WHERE id = any($1::int[])', [1, 2, 3])\r\n\r\n```"}}
{"actor":{"display_login":"elprans"}}