Re: Updates on Views? - Mailing list pgsql-general

From Tom Lane
Subject Re: Updates on Views?
Date
Msg-id 16274.985321407@sss.pgh.pa.us
Whole thread Raw
In response to Re: Updates on Views?  (will trillich <will@serensoft.com>)
List pgsql-general
will trillich <will@serensoft.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

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: internationalizing text
Next
From: will trillich
Date:
Subject: from string to table...?