sql DO in rule 9.0rc1

From: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: sql DO in rule 9.0rc1
Date: 2010-09-09 21:07:16
Message-ID: 437E7B75-2FC6-4290-B01B-0FF8802BA6B6@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a technical limitation which prevents DO from being used in rules or am I missing something with this?

CREATE RULE test_update AS ON UPDATE TO test DO INSTEAD DO $$
BEGIN;
RAISE NOTICE 'hello';
END;
$$;

Cheers,
M

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tamanna madaan 2010-09-09 21:07:47 Re: error while autovacuuming
Previous Message David Fetter 2010-09-09 21:06:13 Re: error while autovacuuming