Stuff

netaudit=> CREATE FUNCTION upsertHost( inet ) RETURNS integer AS $$
        BEGIN;
                INSERT INTO tblHosts (host) VALUES ($1);
                SELECT 1;
        EXCEPTION WHEN unique_violation THEN
                UPDATE tblHosts SET lastSeen=NOW() WHERE host=$1;
                SELECT 2;
        END;
$$ LANGUAGE SQL;
ERROR:  syntax error at or near "EXCEPTION"
LINE 5:  EXCEPTION WHEN unique_violation THEN
         ^