Re: features required for SQL 92 conformance

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly