Parametrized array in WHERE IN

1

I am trying to filter using "WHERE IN" with dapper but I'm receiving error. I have tried:

WHERE Channel = ANY(SELECT @Channels) = Npgsql.PostgresException (0x80004005): 42883: operator does not exist: character varying = text[]

WHERE Channel = ANY(@Channels): Npgsql.PostgresException (0x80004005): 22P03: invalid array flags

WHERE Channel IN @Channels: Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "$1"

WHERE Channel IN (@Channels): Npgsql.PostgresException (0x80004005): 42883: operator does not exist: character varying = text[]

Channels is a List<string>

how can I do that?

amazon-redshift
dapper
asked on Stack Overflow Oct 4, 2018 by MuriloKunze • edited Oct 4, 2018 by MuriloKunze

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0