On Tue, Apr 15, 2008 at 11:27:15AM -0400, Chad Showalter wrote: > I don't need to define the view the way I did in my example. I do need the > view to have fields that map to fields in my_audit_table in order to do an > insert into that table with values from the insert statement.
Right. > Here's one solution that seems to work. Change my view to the following, > leave rules the same as before: Looks good, though I would've used NULLs instead of actual values, but it doesn't matter. The reason I was asking about the SP is that you could do: SELECT insert_row(a,b,c); With the appropriate procedure definition and it would still have one roundtrip. But your way works also. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
