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

-----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-----