Re: [SQL] writable joined view

2005-10-25 Thread Richard Huxton
Sarah Asmaels wrote: Hi! I have one table referencing an object in another table through an ID, and a view joining those tables on the ID. I want to create rules to rewrite updates/deletes/inserts on the joined view to act on the real tables. Can you give me some pointers? The documentation has

Re: [SQL] writable joined view

2005-10-25 Thread Wiebe Cazemier
Sarah Asmaels wrote: Hi! I have one table referencing an object in another table through an ID, and a view joining those tables on the ID. I want to create rules to rewrite updates/deletes/inserts on the joined view to act on the real tables. Can you give me some pointers? The documentation has

[SQL] writable joined view

2005-10-24 Thread Sarah Asmaels
Hi! I have one table referencing an object in another table through an ID, and a view joining those tables on the ID. I want to create rules to rewrite updates/deletes/inserts on the joined view to act on the real tables. Can you give me some pointers? The documentation has only examples for views