|
hi, though I have worked for a while with SQLServer2000
but I am new to Postgres (and also new to using mailing lists), so please bear
with me if I am slower to pick these up. I am trying to write a function in plpgsql that returns a
group of people. The group is defined by a set of conditions. These conditions
are stored in a separate table so that it is configurable by the user. So far so good, but here comes the trick: one of the
conditions could be that people are already members of a parent group –
so I need to call this function recursively. At the top level the groupid=parentgroupid So what I am trying to do is basically Function dyn_group (groupheaderid) If groupid=parenttgroupid then
return all people Else Select from dyngroup(groupparentid)
INNER JOIN people WHERE …all sorts of conditions Endif So what it should do is to look up if a group has parent, if
yes look up, if it has parent and so on until we get a groupid=parentgroupid
where it returns all people, use that in the INNER JOIN and return a recordset,
than use this recordset in the INNER JOIN, return a recordset and so on until
the original function returns the recordset that contains people who are
members of all these groups. In practice however this doesn’t seem to work as the
function never returns. Should this work in theory? Is this the recommended
approach? Thanks for the help. SWK |
