Re: [GENERAL] cast list of oid

2011-04-08 Thread Pavel Stehule
Hello 2011/4/8 salah jubeh : > 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(ar

[GENERAL] cast list of oid

2011-04-08 Thread salah jubeh
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::textFROM pg_group; Regards Best Regard Eng. Salah Al Jubeh PalestinePolytechnic University College of Applied Science Computer Science P.O. Box 198 Mobi