Troels,
> I'm thinking: Updatable views. As far as I know, SQL-92 has updatable
> views in the sense that views deriving from only one base table should be
> updatable (as long as the view construction makes it possible for the DBMS
> to deduct where to make changes in the base table). Sure, PostgreSQL has
> rules, but that hardly qualifies as real support for updatable views.
Damn, yeah, you're right. Neil was going to code something so that "WITH
UPDATE" would automatically translate into the creation of 2-3 rules. But
he got distracted ...
--
-Josh Berkus
Aglio Database Solutions
San Francisco