Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux