Re: Rule Question - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Rule Question
Date
Msg-id CAKoxK+7gjKdVjfsqpkXptiUVOTic417E+4kJvtDUA91KmNrTPw@mail.gmail.com
Whole thread Raw
In response to Rule Question  (Andrew Bartley <ambartley@gmail.com>)
List pgsql-general
On Thu, Jul 25, 2013 at 8:44 AM, Andrew Bartley <ambartley@gmail.com> wrote:

> create rule cats_test as on update to cats do set a = new.b;
>

I would use a column trigger attached to the 'a' column. Rules are
better for query rewriting rather than from semantic changes.
That's my opinion.

Luca


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Why are stored procedures looked on so negatively?
Next
From: Luca Ferrari
Date:
Subject: Re: Tablespace on Postgrsql