On Sat, 20 Oct 2001, Steve Howe wrote: > Hello all!! > > > I'm developer of a interface for PostgreSQL for the Borland Kylix > and Delphi tools (http://www.vitavoom.com). I've run into the following > problems with catalogs: > > - pg_group: the grolist field is an array. How can I make a query > that tell me the usernames of a group ? > - pg_proc: the proargtypes field is an array. How can I make a query > that will link those types to the pg_types catalog ??? > > This catalog design seems a very crude hack to make the things > working for me. Can't those relations be separated in another table ? Or > maybe a function that can search for a value in array, and make a wroking > reference for an array > element in a relation (something like "select typname from pg_type, pg_group > where oid > in grolist"). > I also quote the PotgreSQL user manual > (http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/arrays.html):
In the contrib/ directory are procedures to search arrays for values. This may help. -- Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
