A question about rules - Mailing list pgsql-general

From stan
Subject A question about rules
Date
Msg-id 20200118165325.GB21472@panix.com
Whole thread Raw
Responses Re: A question about rules
List pgsql-general
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.

Sorry for such a newbie question.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



pgsql-general by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: RPC via WebSockets.
Next
From: Adrian Klaver
Date:
Subject: Re: A question about rules