William Garrison <postgres(at)mobydisk(dot)com> writes:
> WHERE customerid = ANY($1);
> Results in the error:
> ERROR: op ANY/ALL (array) requires array on right side
>
> I tried casting the character string to an array afterward:
>
> WHERE customerid = ANY($1::bytea);
> which results in:
> ERROR: cannot cast type character varying to bytea
You meant array or bytea?
neo=# select '{1, 2, 3}'::int[];
int4
---------
{1,2,3}
(1 record)
neo=#
--
Jorge Godoy <jgodoy(at)gmail(dot)com>