update_tables_0.2.x-0.3.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Tue, 08 Jan 2008 12:30:20 +0000
changeset 1 d08cda9d7c1a
parent 0 bb0aa2102206
permissions -rw-r--r--
* 'vmm' - fixed exception names

-- $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;