Re: cast list of oid

Hello

2011/4/8 salah jubeh <s_jubeh(at)yahoo(dot)com>:
> is it possible to cast a list of  oids  . i.e something like below. Or I
> need to write a procedure
>
> SELECT groname, grolist::regclass::text FROM pg_group;
>

what is list? Is it a array?

you can use a unnest and array()

postgres=# select array(select unnest(array[25,26,27]::oid[])::regtype);
?column?
────────────────
{text,oid,tid}
(1 row)

Regards

Pavel Stehule

>
>  Regards
>
> Best Regard
>
> Eng. Salah Al Jubeh
> Palestine Polytechnic University
> College of Applied Science
> Computer Science
> P.O. Box 198
> Mobile:++97259369122
> Tel:++97222254680
>
>
>