Re: shortcut for select * where id in (arrayvar)

Ivan Sergio Borgonovo wrote:
> I'm still investigating on how to return array elements.
>
> I came out with something like:
>
> create or replace function auz(out _errcode int, out _errmsg text)
> returns setof record as $$
> declare
> errcode int[];
> errmsg text[];
> _row record;
> begin
> errcode[1]:=1;
> errmsg[1]:='pota pota';
> errcode[2]:=3;
> errmsg[2]:='bau bau';
> for i IN coalesce(array_lower(errcode,1),0) ..
> coalesce(array_upper(errcode,1),-1)
> loop _errcode:=errcode[i];
> _errmsg:=errmsg[i]; return next;
> end loop;
> return;
> end;
> $$ language plpgsql;
>
> I'd like to avoid to hard code error messages in the function so I
> was thinking about adding a table with error_id, error_messages and
> change the for loop with something similar to
>
> for _row in
> select err, msg from errortable where err in (errcode)
>
> where errcode is an array.
> That syntax doesn't work... is there any alternative syntax to keep
> stuff short and not error prone?
>

How about something like:

select err, msg from errortable
where err in (array_to_string(errcode, ','))

b