Re: A question about rules

2020-01-20 Thread stan
On Sun, Jan 19, 2020 at 08:52:36AM -0800, Adrian Klaver wrote: > On 1/19/20 2:32 AM, stan wrote: > Please post to list also. > Ccing list. > > > On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote: > > > On 1/18/20 8:53 AM, stan wrote: > > > > So, I just discovered the rules system. As I

Re: A question about rules

2020-01-19 Thread Adrian Klaver
On 1/19/20 2:32 AM, stan wrote: Please post to list also. Ccing list. On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote: 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

Re: A question about rules

2020-01-18 Thread Adrian Klaver
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

A question about rules

2020-01-18 Thread stan
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/functi