Hello
2011/4/8 salah jubeh <[email protected]>:
> 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
>
>
>
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
