Re: RETURNING and DO INSTEAD ... Intentional or not?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: RETURNING and DO INSTEAD ... Intentional or not?
Date: 2007-09-14 18:59:40
Message-ID: 46EADA1C.6080707@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bruce Momjian wrote:
> Josh Berkus wrote:
>> All,

>> -- Make it possible to use RETURNING together with conditional DO INSTEAD
>> rules, such as for partitioning setups.
>
> Added to TODO:
>
> * Make it possible to use RETURNING together with conditional DO INSTEAD
> rules, such as for partitioning setups
>
> http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php
>

Would it make sense to expand this to something like:

Make it possible for rules to return affected tuples?

I come to this because if you use a rule to create an updateable view,
you never know how many rows the view actually updated.

Joshua D. Drake

>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG6tocATb/zqfZUUQRAnlyAJ48kiUurDxxlnVINhY0NyhnvqFBTgCcD3kk
lcIG2DupUSPnscg+vUhhMC0=
=GAHe
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 19:02:54 Re: [HACKERS] AutoVacuum Behaviour Question
Previous Message Stefan Kaltenbrunner 2007-09-14 18:59:22 Re: PL/TCL Patch to prevent postgres from becoming multithreaded