Skip site navigation (1) Skip section navigation (2)

non-recursive WITH clause support

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: non-recursive WITH clause support
Date: 2007-03-09 17:37:55
Message-ID: 87tzwu2u8c.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-patches by date

Next:From: Simon RiggsDate: 2007-03-09 19:24:13
Subject: scan_recycle_buffers
Previous:From: Gregory StarkDate: 2007-03-09 15:18:24
Subject: Updated packed varlena patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group