Re: re[SQL] cursively isolate pedigrees, based only on person_id, mother_id and father_id

On the assumption that you wish to generate the pedigrees for analysis or charting, why not perform the recursion in those layers (or their supporting software), This does not require a large number of sql calls since using an in-clause each call will gather one generation (ascending or descendi

re[SQL] cursively isolate pedigrees, based only on person_id, mother_id and father_id

Hello! Given a table "persons", where the individuals are bound to each other only via the foreign keys mother_id and father_id as self joins on persons, like that create table persons ( id serial primary key, sex character(1), father_id integer default null references persons(id) on update casc

Re: [SQL] [GENERAL] Data audit trail techniques in postgresql

Alvaro Herrera wrote: > Perhaps, but I have heard of people using it successfully recently, > whereas Nathaniel reported that audittrail2 seems to have obvious > bugs. Thanks for the tip. Do to poor searching on my part tablelog fell under my radar. I'll try and out and see how it goes. Nathaniel

[SQL] hopeless, SQL not resolved yet

Thank you very much for the answer! No, I'm not that good... I got finally a fully kinky SQL, which resolves nothing and runs endless for a couple of test records... I think, it would be better to open for this matter a new thread... Regards Rawi -- View this message in context: http://www.n