Hierarchical queries in pgsql

Started by Betsemesover 25 years ago4 messagesgeneral
Jump to latest
#1Betsemes
betsemes@ematic.com

Do pgsql features an equivalent to Oracle's hierarchical queries? Those that

can be done with "start with" and "connect to" clauses. Thanks.

Efrain Caro

Try Ematic.com
Where everyone can buy, or sell, new or used, products online in safe and secure manner. Accept credit cards on your web site (no merchant account required). Get free email, web hosting, e-commerce, affiliate program and more at http://www.ematic.com.

#2Lincoln Yeoh
lyeoh@pop.jaring.my
In reply to: Betsemes (#1)
Re: Hierarchical queries in pgsql

I don't think so.

I'm wondering whether that feature would make Oracle faster for hierachical
stuff, or just more convenient.

Cheerio,
Link.

At 06:51 AM 02-01-2001 -0500, Betsemes wrote:

Do pgsql features an equivalent to Oracle's hierarchical queries? Those that

can be done with "start with" and "connect to" clauses. Thanks.

Efrain Caro

Try Ematic.com
Where everyone can buy, or sell, new or used, products online in safe and

secure manner. Accept credit cards on your web site (no merchant account
required). Get free email, web hosting, e-commerce, affiliate program and
more at http://www.ematic.com.

Show quoted text
#3Sungchul Park
scpark@gen128.com
In reply to: Lincoln Yeoh (#2)
Re: Re: Hierarchical queries in pgsql

I don't think so.

I'm wondering whether that feature would make Oracle faster for hierachical
stuff, or just more convenient.

IMHO, Both of it. It was very fast and make simple DB query and schema.

Cheerio,
Link.

At 06:51 AM 02-01-2001 -0500, Betsemes wrote:

Do pgsql features an equivalent to Oracle's hierarchical queries? Those that

can be done with "start with" and "connect to" clauses. Thanks.

Efrain Caro

Try Ematic.com
Where everyone can buy, or sell, new or used, products online in safe and

secure manner. Accept credit cards on your web site (no merchant account
required). Get free email, web hosting, e-commerce, affiliate program and
more at http://www.ematic.com.

Park, Sungchul / mailto:scpark@gen128.com
gen128, inc. - The internet company powered by open source.
http://www.gen128.com / Voice : +82-2-3017-0128 / Fax : +82-2-3017-1128
238-9 poi kangnam, #601 poongjoen bldg., Seoul 135-250, Republic of Korea

#4Betsemes
betsemes@ematic.com
In reply to: Sungchul Park (#3)
Re: Re: Hierarchical queries in pgsql

I don't think so.

I'm wondering whether that feature would make Oracle faster for

hierachical

stuff, or just more convenient.

I don't really know about that, but all hierarchical queries that I've done

have been pretty fast. And they are indeed very, very convenient.

Cheerio,
Link.

At 06:51 AM 02-01-2001 -0500, Betsemes wrote:

Do pgsql features an equivalent to Oracle's hierarchical queries? Those

that

can be done with "start with" and "connect to" clauses. Thanks.

Efrain Caro

Try Ematic.com
Where everyone can buy, or sell, new or used, products online in safe and secure manner. Accept credit cards on your web site (no merchant account required). Get free email, web hosting, e-commerce, affiliate program and more at http://www.ematic.com.