Search Postgresql Archives

recursive function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux