Re: RETURNING and DO INSTEAD ... Intentional or not? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: RETURNING and DO INSTEAD ... Intentional or not?
Date
Msg-id 46EADA1C.6080707@commandprompt.com
Whole thread Raw
In response to Re: RETURNING and DO INSTEAD ... Intentional or not?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: RETURNING and DO INSTEAD ... Intentional or not?
List 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-----


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: RETURNING and DO INSTEAD ... Intentional or not?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] AutoVacuum Behaviour Question