From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc:
Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: top-level DML under CTEs
Date:
2010-09-13 19:14:49
Message-ID:
AANLkTinVeefjte4_NvFwPWfEvanR=49Q9eeajjV42Bc4@mail.gmail.com (view raw or flat )
Thread:
2010-09-13 13:15:24 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-13 13:20:19 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-13 18:43:18 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-13 19:14:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-14 00:44:46 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-14 15:50:31 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-09-14 18:59:43 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-14 19:51:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-14 20:28:33 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-09-14 22:49:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-14 23:02:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-15 01:15:12 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-15 03:22:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-15 04:38:17 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-17 01:48:35 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-22 23:59:15 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-09-23 06:12:51 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-09-23 09:22:54 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-09-29 19:14:07 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-10-01 08:24:23 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-10-03 13:47:28 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
2010-10-04 11:46:23 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-10-04 21:59:07 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-10-05 01:49:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-15 01:04:06 from Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Lists:
pgsql-hackers pgsql-rrreviewers
On Mon, Sep 13, 2010 at 2:43 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> Just to be clear, the attached patch is missing the part of the wCTE
> that allows queries of the form:
> WITH foo AS (DELETE * FROM bar RETURNING *) <any query using foo>
Understood.
> IOW, your CTE query has to be a select. This is still highly useful
> however.
Agreed.
> The patch itself looks very clean after a quick glance
> (which is all I can offer ATM unfortunately).
Yeah, I haven't had a chance to look at it either, just wanted to send props.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-09-13 19:28:22Subject : Re: Report: removing the inconsistencies in our CVS->git conversion Previous :From : Merlin MoncureDate : 2010-09-13 18:43:18Subject : Re: top-level DML under CTEs
pgsql-rrreviewers by date
Next :From: Hitoshi HaradaDate: 2010-09-14 00:44:46Subject : Re: top-level DML under CTEsPrevious :From : Merlin MoncureDate : 2010-09-13 18:43:18Subject : Re: top-level DML under CTEs
