"Easy" SQL query

[INTLuis]

Hello,

I've created the query:

SELECT "Clients"."Out" FROM "Clients" LEFT OUTER JOIN "Clients interested" ON "Clients"."Id" = "Clients interested"."Id" WHERE "Clients interested"."Out" = 0

It works perfectly. (803 registers)

BUT, now I want to update the obtained recordset (803 registers with the "Clients"."Out" field) to:

UPDATE [Recordset] SET [Field "Clients"."Out"] = 0

How could I build the complete query in ONLY ONE, joining the keywords SELECT and UPDATE?

JUST ONE QUERY!

Thank you very much!

 

[rycamor]

See RULE information:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createrule.html

And search more about rules here:

http://www.postgresql.org/search.cg...l.org/docs/view.php?version=7.3&idoc=1&q=rule

Rules in PostgreSQL are similar to triggers, but are ONLY special queries which are defined to do additional action to any query on a table.

In this case you would want an ON SELECT rule to perform your additional update.

Rules can also be applied to views. In fact, this is the mechanism by which views can be made updateable in PostgreSQL.

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html