Re: [HACKERS] [SQL] rule for update view that updates/inserts into 2 tables

2008-04-15 Thread Chad Showalter
7; as c FROM my_table t; Does this seem reasonable to you? Do you problems with this approach? Thanks again for your help, Chad From: Robins Tharakan [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 8:34 PM To: Chad Showalter Cc: [EMAIL PROTECTED] Subject: Re: [SQL] rule for

[HACKERS] rule for update view that updates/inserts into 2 tables

2008-04-14 Thread Chad Showalter
I've posted this on pgsql-general and pgsql-sql, and haven't got any responses. If any of you would be able to take a look at this for me and give some feedback, I'd be obliged. I would like to create a rule that, by updating a view, allows me to update one table and insert into another. T