Re: Passing arrays to stored procedures

[Jorge Godoy <jgodoy(at)gmail(dot)com>]

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>