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@xxxxxxxxxxx
