WITH RECURSIVE ... simplified syntax?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема WITH RECURSIVE ... simplified syntax?
Дата
Msg-id 200810081611.46243.josh@agliodbs.com
обсуждение исходный текст
Ответы Re: WITH RECURSIVE ... simplified syntax?  ("Dickson S. Guedes" <guediz@gmail.com>)
Re: WITH RECURSIVE ... simplified syntax?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: WITH RECURSIVE ... simplified syntax?  (David Fetter <david@fetter.org>)
Re: WITH RECURSIVE ... simplified syntax?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
All,

I was discussing WITH RECURSIVE the other day, and realized that one thing 
which we're not getting with this patch is a simplest-case simple syntax 
which 75% of users are looking for.  You know, the ones with simple 
proximity trees who just want to find all children of one parent.

Would it be a worth it for us to implement a non-standard simple syntax 
sugar on top of WITH RECURSIVE?  Or, at least, something like 
CONNECT_BY()?

-- 
--Josh

Josh Berkus
PostgreSQL
San Francisco


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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Fixes for psql describeOneTableDetails
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [WIP] plpgsql is not translate-aware