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

Re: top-level DML under CTEs

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: top-level DML under CTEs
Date: 2010-09-22 23:59:15
Message-ID: 4C9A9853.2070609@cs.helsinki.fi (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-rrreviewers
On 2010-09-17 4:48 AM, Hitoshi Harada wrote:
> 2010/9/15 Hitoshi Harada<umi(dot)tanuki(at)gmail(dot)com>:
>> Well, I didn't know it is allowed. That would look like the way to go.
>
> I made changes to the previous version, so that it avoids to resolve
> CTE name duplication.

This patch still doesn't address the issue Tom raised here:
http://archives.postgresql.org/pgsql-hackers/2010-09/msg00753.php

For WITH .. INSERT .. WITH .. SELECT ..; this patch works OK, but not so 
much for VALUES:

=# CREATE RULE barrule AS ON UPDATE TO bar DO INSTEAD
-# WITH RECURSIVE t AS (SELECT -1)
-# INSERT INTO bar
-# WITH t AS (SELECT 1)
-# VALUES((SELECT * FROM t));
CREATE RULE

=# \d bar
       Table "public.bar"
  Column |  Type   | Modifiers
--------+---------+-----------
  a      | integer |
Rules:
     barrule AS
     ON UPDATE TO bar DO INSTEAD  WITH RECURSIVE t AS (
          SELECT 1
         ), t AS (
          SELECT (-1)
         )
  INSERT INTO bar (a)  WITH RECURSIVE t AS (
                  SELECT 1
                 ), t AS (
                  SELECT (-1)
                 )

   VALUES (( SELECT t."?column?"
            FROM t))


Regards,
Marko Tiikkaja

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2010-09-23 00:32:41
Subject: Re: Standby registration
Previous:From: Bruce MomjianDate: 2010-09-22 23:47:12
Subject: Re: Git conversion status

pgsql-rrreviewers by date

Next:From: Hitoshi HaradaDate: 2010-09-23 06:12:51
Subject: Re: top-level DML under CTEs
Previous:From: Pavel StehuleDate: 2010-09-22 04:44:58
Subject: Re: wip: functions median and percentile

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