William Garrison <postgres@xxxxxxxxxxxx> 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@xxxxxxxxx>
