Am Mittwoch, den 05.10.2005, 18:37 -0700 schrieb CSN: > Just so I know (and am armed ;) ), are there any new > comparable features in MySQL 5.0 that aren't in > PostgreSQL up to the forthcoming 8.1? AFAIK, PG just > lacks updatable views (which are on the TODO). > > MySQL 5.0 new features > http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html Nice detail: "Views that use UNION ALL are disallowed even though they might be theoretically updatable, because the implementation uses temporary tables to process them." not sure if silently declare part of the view as updateable is SQL standard... you can do all you want if you add the update (and also insert) rule to the view definition (which is in fact only a select rule in PG) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
