Akmal Akmalhojaev wrote:
Hello! I have the following question.

For example I have a role ID1 with members ID2 and ID3.
Role ID2 has also members ID4 and ID5. It means that roles ID4 and ID5 are
members of ID1.
The question: Is there any function in PostgreSQL, that finds all the
members of role ID1 - even such members, as ID4 and ID5.

Akmal, this isn't really a question for the hackers list. Please try on "general" or "admin".

However, I know of no function that will recursively expand member lists. You could easily write your own of course, but you'll want to decide how to handle the "inherits" flag.

  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to