PostgreSQL 9.3 Will Feature UPDATEable Views
Posted: 12 Dec 2012, 19:50
From Slashdot:
I myself am very glad for this. I've loved PostgresSQL for years upon years; much easier than MySQL to me.
http://developers.slashdot.org/story/12 ... able-views
Unknown Lamer wrote:Picking up work abandoned around Postgres 8.2, a patch recently hit the PostgreSQL 9.3 branch that adds SQL-92 automatically updatable views. For many common cases, you will no longer have to write hairy triggers to fake UPDATE support (e.g. if you have a view that hides a few internal columns). Limitations currently include only supporting views with at most one table in the FROM clause. This complements the under-advertised INSTEAD OF trigger support added in 9.1.
I myself am very glad for this. I've loved PostgresSQL for years upon years; much easier than MySQL to me.
http://developers.slashdot.org/story/12 ... able-views