non-recursive WITH clause support

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема non-recursive WITH clause support
Дата
Msg-id 87tzwu2u8c.fsf@stark.xeocode.com
обсуждение исходный текст
Ответы Re: non-recursive WITH clause support  (Bruce Momjian <bruce@momjian.us>)
Re: non-recursive WITH clause support  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: non-recursive WITH clause support  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-patches
Here's an updated patch that fixes the bug I had. This is now functional basic
non-recursive WITH clause support.

 http://community.enterprisedb.com/recursive/with-pg82stable-v2.patch.gz

It's a pretty short simple patch as is; it just directly inlines any WITH
clauses as if they had been written as subqueries. We'll have to do something
much more clever to get recursive queries to work but for non-recursive
queries that's sufficient.

Example:

postgres=# with a as (select 1 as x) select * from (select * from a) as x;
 x
---
 1
(1 row)




--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Updated packed varlena patch
Следующее
От: "Simon Riggs"
Дата:
Сообщение: scan_recycle_buffers