diff -r 000000000000 -r bb0aa2102206 update_tables_0.2.x-0.3.pgsql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/update_tables_0.2.x-0.3.pgsql Sun Jan 06 18:22:10 2008 +0000 @@ -0,0 +1,8 @@ +-- $Id$ + +DROP VIEW ma_aliases_count; +CREATE OR REPLACE VIEW vmm_alias_count AS + SELECT count(DISTINCT address) AS aliases, gid + FROM alias + GROUP BY gid; +