Postgres Pro
Downloads
Home   >   mailing lists

Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)
Date
Msg-id k14hpn$7vv$1@ger.gmane.org
Whole thread Raw
In response to Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)
Next
From: Thomas Kellerer
Date:
Subject: Re: What text format is this and can I import it into Postgres?