Re: Oracle 'connect by prior' now eaiser in 7.3?

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Oracle 'connect by prior' now eaiser in 7.3?
Дата
Msg-id 3F6FC51F.6090105@joeconway.com
обсуждение исходный текст
Ответ на Oracle 'connect by prior' now eaiser in 7.3?  ("Merrall, Graeme" <gmerrall@team.aol7.com.au>)
Список pgsql-sql
Merrall, Graeme wrote:
> Am I right in thinking that recursive procedures and procs returning row
> sets would allow us to better emulate this behaviour? As anyone looked
> at it yet?
> 

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.

HTH,

Joe



В списке pgsql-sql по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: selecting duplicate records
Следующее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: Using sql statements in file