Re: A question about rules - Mailing list pgsql-general

From Adrian Klaver
Subject Re: A question about rules
Date
Msg-id ea5d5d07-4167-6933-9862-eb3d9d1fa996@aklaver.com
Whole thread Raw
In response to A question about rules  (stan <stanb@panix.com>)
List pgsql-general
On 1/18/20 8:53 AM, stan wrote:
> So, I just discovered the rules system. As I understand it, it can be used
> to rewrite queries before they are passed to the query processor.
> 
> I was wondering if I could use this to resolve a long standing frustration
> of mine. I often need to declare a column as NON NULL, and create a
> trigger/function to auto populate it with something more complex than a
> simple sequence. This need arises fairly often for me, and I would like to
> come up with a good way to implement this.

Stay away from rules, they will only drive you to distraction. Stick 
with triggers they are a lot easier to understand and implement.

> 
> Sorry for such a newbie question.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: stan
Date:
Subject: A question about rules
Next
From: Adrian Klaver
Date:
Subject: Re: A question about rules