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