{"action":"opened","issue":{"url":"https://api.github.com/repos/lib/pq/issues/721","repository_url":"https://api.github.com/repos/lib/pq","labels_url":"https://api.github.com/repos/lib/pq/issues/721/labels{/name}","comments_url":"https://api.github.com/repos/lib/pq/issues/721/comments","events_url":"https://api.github.com/repos/lib/pq/issues/721/events","html_url":"https://github.com/lib/pq/issues/721","id":305138699,"number":721,"title":"Further support for arrays in queries","user":{"login":"ralphking","id":1839765,"avatar_url":"https://avatars2.githubusercontent.com/u/1839765?v=4","gravatar_id":"","url":"https://api.github.com/users/ralphking","html_url":"https://github.com/ralphking","followers_url":"https://api.github.com/users/ralphking/followers","following_url":"https://api.github.com/users/ralphking/following{/other_user}","gists_url":"https://api.github.com/users/ralphking/gists{/gist_id}","starred_url":"https://api.github.com/users/ralphking/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ralphking/subscriptions","organizations_url":"https://api.github.com/users/ralphking/orgs","repos_url":"https://api.github.com/users/ralphking/repos","events_url":"https://api.github.com/users/ralphking/events{/privacy}","received_events_url":"https://api.github.com/users/ralphking/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-14T12:30:24Z","updated_at":"2018-03-14T12:30:24Z","closed_at":null,"author_association":"NONE","body":"pq.Array() does not return a value that can be used as an array in all situations.\r\n\r\nUsing `pq.Array([]int{1,2})` as `$1` for these examples.\r\n\r\nThis works as expected:\r\n```\r\nSELECT * from some_table WHERE some_column = ANY($1)\r\n``` \r\n\r\nThis does not:\r\n```\r\nSELECT * from some_table WHERE some_column IN($1)\r\n``` \r\n\r\nThis does not:\r\n```\r\nSELECT * from some_table WHERE some_column BETWEEN $1[1] AND $1[2]\r\n``` \r\n\r\nPostgres complains that the type isn't actually an array, which is true.\r\n\r\nThere are plenty of ways around the issue, but is this something that anyone else would want support for? \r\n\r\n"}}
{"actor":{"display_login":"ralphking"}}