Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)
Date: 2012-08-23 06:15:20
Message-ID: k14hpn$7vv$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Travers, 23.08.2012 05:22:
> The fact that this allows you to create essentially derived values
> from groups of re-used columns is itself remarkable and can be used
> to implement path traversal etc. which is not directly supported in
> PostgreSQL in the sense that it is in Oracle or DB2.

What exactly do you mean with "path traversal" here? If you are talking about Oracle's CONNECT BY
then this is fully supported in PostgreSQL using a recursive common table expression.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2012-08-23 06:22:53 Re: What text format is this and can I import it into Postgres?
Previous Message David Johnston 2012-08-23 05:36:59 Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)