Horton

Re: Query Plan Columns

David Fetter <david@fetter.org>

View thread
From: David Fetter <david@fetter.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, "David E. Wheeler" <david@kineticode.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-06T17:17:05Z
Lists: pgsql-hackers 
On Fri, Nov 05, 2010 at 01:39:07PM -0700, Josh Berkus wrote:
> 
> > Of course, there are containers too, which are not in your list at all.
> > How do you intend to represent the tree-ish structure in a flat table?
> 
> Andrew: we'll use a proximity tree.

Adjacency list?

If so, in my experience, it's best to separate the node descriptions
from the adjacency list that links them together.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate