Re: Hierarchical queries a la Oracle patch. for 7.3rc1.

Поиск
Список
Период
Сортировка
От Fernando Nasser
Тема Re: Hierarchical queries a la Oracle patch. for 7.3rc1.
Дата
Msg-id 3DEFBD42.6050506@redhat.com
обсуждение исходный текст
Ответ на Re: Hierarchical queries a la Oracle patch. for 7.3rc1.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Hierarchical queries a la Oracle patch. for 7.3rc1.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Bruce Momjian wrote:> This is a pretty sizable patch, and there was discussion
about it.

On which there were objections that were not addressed.  I, for instance,
complained about the addition of a syntax that is neither SQL not Oracle.  And
the last version of the patch still has it.

Also, I felt that there was a consensus that we should implement the SQL99 (and
DB2) recursive queries instead because:
1) It is the _standard_
2) The Oracle clause is less generic (less powerful) than the standard
3) One can add the Oracle weird clause as a syntactic sugar to a specific
recursive query construct (as I have shown in one posting)
4) Adding the Oracle clause as a hack may prevent us to implement the real SQL thing






--
Fernando Nasser
Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Hierarchical queries a la Oracle patch. for 7.3rc1.
Следующее
От: Nicolai Tufar
Дата:
Сообщение: Re: [HACKERS] Patch to make Turks happy.