That's great - thanks very much Nick
-----Original Message----- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: 01 July 2005 18:30 To: Nick Stone Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Some help please Nick, > I'm interested in using the connectby() function which I gather from > the lists can be used in a similar way to the Oracle connect by ... > PRIOR functionality. Does anybody know where there's an example of > this in use or better still could somebody post an example. Examples are in the /contrib directory where the connectby source is: /contrib/tablefunc/README.tablefunc -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly