Re: Updates on Views?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: will trillich <will(at)serensoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Updates on Views?
Date: 2001-03-23 04:23:27
Message-ID: 16274.985321407@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

will trillich <will(at)serensoft(dot)com> writes:
> is it possible to have a rule DO INSTEAD more-than-one-thing?

Sure. Observe the CREATE RULE reference page:

CREATE RULE name AS ON event
TO object [ WHERE condition ]
DO [ INSTEAD ] action

where action can be:

NOTHING
|
query
|
( query ; query ... )
|
[ query ; query ... ]

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2001-03-23 04:31:16 Lost Trigger(s)?
Previous Message will trillich 2001-03-23 04:06:49 internationalizing text