[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

Re: [GENERAL] cast list of oid

2011-04-08 Thread Pavel Stehule
Hello 2011/4/8 salah jubeh s_ju...@yahoo.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