Re: Rule Question

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Andrew Bartley <ambartley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rule Question
Date: 2013-07-25 07:36:18
Message-ID: CAKoxK+7gjKdVjfsqpkXptiUVOTic417E+4kJvtDUA91KmNrTPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 25, 2013 at 8:44 AM, Andrew Bartley <ambartley(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2013-07-25 07:39:28 Re: Tablespace on Postgrsql
Previous Message Pavel Stehule 2013-07-25 07:25:46 Re: Why are stored procedures looked on so negatively?