Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle 'connect by prior' now eaiser in 7.3? - Mailing list pgsql-sql

From Randolf Richardson, DevNet SysOp 29
Subject Re: Oracle 'connect by prior' now eaiser in 7.3?
Date
Msg-id Xns9435CF5523F2Err8xca@200.46.204.72
Whole thread Raw
In response to Oracle 'connect by prior' now eaiser in 7.3?  ("Merrall, Graeme" <gmerrall@team.aol7.com.au>)
List pgsql-sql
Tree view 
[sNip]
> See connectby() in contrib/tablefunc. Someone was working on SQL99 
> recursive queries but it didn't get done for 7.4 -- perhaps it will be 
> in 7.5. In the meantime, connectby() is in 7.3 and might work for you.
       Oracle 8i doesn't seem to have any special indexing to handle this 
efficiently.  Do you happen to know if PostgreSQL will have a special 
indexing option for this feature?  If it does, it will very likely provide a 
major performance advantage over Oracle.

-- 
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.

pgsql-sql by date:

Previous
From: "Randolf Richardson, DevNet SysOp 29"
Date:
Subject: Re: SOLVED: Emulating 'connect by prior' using stored proc
Next
From: "Randolf Richardson, DevNet SysOp 29"
Date:
Subject: Re: Closed