Re: [SQL] Table Design for Hierarchical Data

2010-04-12 Thread Leif Biberg Kristensen
On Monday 12. April 2010 17.37.58 Yeb Havinga wrote: > Leif Biberg Kristensen wrote: > > On Monday 12. April 2010 16.57.38 Rob Sargent wrote: > > > >> Believe me: "ego-ma-pa" will correctly define genealogical relationships > >> (at least among humans). > >> > > > > Yes, but a family tree i

Re: [SQL] Table Design for Hierarchical Data

2010-04-12 Thread Yeb Havinga
Leif Biberg Kristensen wrote: On Monday 12. April 2010 16.57.38 Rob Sargent wrote: Believe me: "ego-ma-pa" will correctly define genealogical relationships (at least among humans). Yes, but a family tree is not a hierarchical tree as defined in database theory. Believe me: I'm a genea

Re: [SQL] Table Design for Hierarchical Data

2010-04-12 Thread Leif Biberg Kristensen
On Monday 12. April 2010 16.57.38 Rob Sargent wrote: > Believe me: "ego-ma-pa" will correctly define genealogical relationships > (at least among humans). Yes, but a family tree is not a hierarchical tree as defined in database theory. Believe me: I'm a genealogist. Hint: Where is the root node

Re: [SQL] Table Design for Hierarchical Data

2010-04-12 Thread Rob Sargent
Believe me: "ego-ma-pa" will correctly define genealogical relationships (at least among humans). On 04/12/2010 02:14 AM, Achilleas Mantzios wrote: > Στις Thursday 08 April 2010 17:59:01 ο/η Rob Sargent έγραψε: >> The "parent" node in a genealogy is the mother-father tuple, so given >> that as a s

Re: [SQL] Howto get a group_number like row_number for groups

2010-04-12 Thread msi77
Hi, dense_rank() over (order by object) % 2 > Hi > I'd like to have an alternating colorindex in the output of a query that > consecutive rows that are the same within a colum the same number. > The query generates a readable output from a log-table and a few others > that hold referenc

Re: [SQL] Table Design for Hierarchical Data

2010-04-12 Thread Achilleas Mantzios
Στις Thursday 08 April 2010 17:59:01 ο/η Rob Sargent έγραψε: > The "parent" node in a genealogy is the mother-father tuple, so given > that as a singularity it still fits a tree. No, because the child and parent node would be of different schema. > > On 04/08/2010 12:56 AM, Achilleas Mantzios wrot