On 19/01/2012 12:57 AM, David Salisbury wrote:
Think I'll answer myself on this. I'll join in whatever rows I get from
the self referential query above to the base table, and include the
rank column,
and then figure out some sort of post processing on the resultant view
( I hope ).
Usually recursive common table expressions (`WITH RECURSIVE') are used
to handle queries on self-referential tables. Have a look in the
documentation for more information.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
