{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/814","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/814/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/814/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/814/events","html_url":"https://github.com/npgsql/npgsql/issues/814","id":110411607,"number":814,"title":"How to pass a string array as parameter?","user":{"login":"denyss86study2","id":15030214,"avatar_url":"https://avatars0.githubusercontent.com/u/15030214?v=4","gravatar_id":"","url":"https://api.github.com/users/denyss86study2","html_url":"https://github.com/denyss86study2","followers_url":"https://api.github.com/users/denyss86study2/followers","following_url":"https://api.github.com/users/denyss86study2/following{/other_user}","gists_url":"https://api.github.com/users/denyss86study2/gists{/gist_id}","starred_url":"https://api.github.com/users/denyss86study2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denyss86study2/subscriptions","organizations_url":"https://api.github.com/users/denyss86study2/orgs","repos_url":"https://api.github.com/users/denyss86study2/repos","events_url":"https://api.github.com/users/denyss86study2/events{/privacy}","received_events_url":"https://api.github.com/users/denyss86study2/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2015-10-08T09:52:53Z","updated_at":"2018-02-13T16:46:35Z","closed_at":"2015-10-08T16:22:19Z","author_association":"NONE","body":"In documentation there is no working sample for passing string array to PostgreSQL, but as far as I understand, I have to do the following:\n\n```\ncommand.CommandText = \"... WHERE Id IN (:myarray)\";\ncommand.Parameters.Add(\"myarray\", NpgsqlDbType.Array | NpgsqlDbType.Varchar).Value = getStringArray();\n```\n\nHowever, after executing this code, I receive the following error:\n\n```\nERROR: 42883: operator does not exist: character varying = character varying[]\n```\n\nWe don't want to use `String.Join` for this, because it may cause SQL Injections.\n\nSystem settings: `Npgsql 2.2.5`, `Windows 10`, `.NET 4.5.1`, `ASP.NET MVC`\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/365327248","html_url":"https://github.com/npgsql/npgsql/issues/814#issuecomment-365327248","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/814","id":365327248,"user":{"login":"SMASH1337","id":7965621,"avatar_url":"https://avatars1.githubusercontent.com/u/7965621?v=4","gravatar_id":"","url":"https://api.github.com/users/SMASH1337","html_url":"https://github.com/SMASH1337","followers_url":"https://api.github.com/users/SMASH1337/followers","following_url":"https://api.github.com/users/SMASH1337/following{/other_user}","gists_url":"https://api.github.com/users/SMASH1337/gists{/gist_id}","starred_url":"https://api.github.com/users/SMASH1337/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SMASH1337/subscriptions","organizations_url":"https://api.github.com/users/SMASH1337/orgs","repos_url":"https://api.github.com/users/SMASH1337/repos","events_url":"https://api.github.com/users/SMASH1337/events{/privacy}","received_events_url":"https://api.github.com/users/SMASH1337/received_events","type":"User","site_admin":false},"created_at":"2018-02-13T16:46:35Z","updated_at":"2018-02-13T16:46:35Z","author_association":"NONE","body":"So I think it's been updated more recently. I can't get @roji script to work but what does work for me is:\r\n\r\n```SELECT * FROM mytable WHERE myId = ANY(:myparam)```"}}
{"actor":{"display_login":"SMASH1337"}}