Re: Passing arrays to stored procedures

William Garrison <postgres@mobydisk.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@gmail.com>