Re: [GENERAL] SELECT Rules or stored procedure

2006-01-20 Thread Andrew - Supernews
On 2006-01-19, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > On Tue, Jan 17, 2006 at 09:55:42PM -0700, Assad Jarrahian wrote: >> q2) How does one get access to the rows just selected in the CREATE >> RULE computation? > > Via NEW and OLD. Read Chapter 34 of the documentation. He's talking about a SE

Re: [GENERAL] SELECT Rules or stored procedure

2006-01-18 Thread Jim C. Nasby
On Tue, Jan 17, 2006 at 09:55:42PM -0700, Assad Jarrahian wrote: > I have a query that takes two tables (join) and does something on it. > Lets say these tables are A and B. > What I need is that everytime one of the tables (A) has its rows > selected, I want to update the count (which is a column

[GENERAL] SELECT Rules or stored procedure

2006-01-17 Thread Assad Jarrahian
I have a query that takes two tables (join) and does something on it. Lets say these tables are A and B. What I need is that everytime one of the tables (A) has its rows selected, I want to update the count (which is a column in A) for that row. I am not sure what is the best way to do this. 1)I c