Received-SPF: pass (temora.hst.terra.com.br: domain of terra.com.br designates
	200.176.10.6 as permitted sender) client-ip=200.176.10.6;
	envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72];
Message-ID: <4665611F.9020500@terra.com.br>
Date: Tue, 05 Jun 2007 10:11:59 -0300
From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
To: pgsql-general@postgresql.org,  pgsql-sql@postgresql.org
Subject: CREATE RULE with WHERE clause
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I need to create a rule, but I need that it have a WHERE clause, how bellow:


CREATE RULE rule_role_sul AS
    ON SELECT TO t1 WHERE roles = 'role_sul'
    DO INSTEAD 
        SELECT field1, field2 FROM t2;

CREATE RULE rule_role_sul AS
    ON SELECT TO t1 WHERE roles = 'role_norte'
    DO INSTEAD 
        SELECT field3, field4 FROM t2;

Someone knows how can I do it?

I appreciate any help

Thanks