Postgres Pro
Downloads
Home   >   mailing lists

Re: Utility of recursive queries? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Utility of recursive queries?
Date
Msg-id 200404090907.56630.josh@agliodbs.com
Whole thread Raw
In response to Utility of recursive queries?  (James Robinson <jlrobins@socialserve.com>)
List pgsql-sql
Tree view 
James,

> Would recursive queries be the trick to doing things like unwinding a
> linked-list to either the head or tail, with:

Yes.  Also check out contrib/ltree and contrib/tablefunc in your handy-dandy 
PostgreSQL source code.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: SQL challenge--top 10 for each key value?
Next
From: Tom Lane
Date:
Subject: Re: Utility of recursive queries?