Thread: Some help please

Some help please

From

"Nick Stone"

Date:

01 July 2005, 16:14:54

Hi,

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.

Many thanks

Nick

Re: Some help please

From

Josh Berkus

Date:

01 July 2005, 17:28:02

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

Re: Some help please

From

"Nick Stone"

Date:

01 July 2005, 17:44:58

That's great - thanks very much

Nick 

-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com] 
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