Re: [GENERAL] how to update a view from a table

2010-01-28 Thread Craig Ringer
Vijay Sharma wrote: > How can i update all the fields of a view from a table(this is table > different from the table which has created the view)? > I don't want to specify the name of the columns in the commands > e.g i want to do something like this > > UPDATE any_view SET (SELECT * FROM any_vie

[GENERAL] how to update a view from a table

2010-01-28 Thread Vijay Sharma
How can i update all the fields of a view from a table(this is table different from the table which has created the view)? I don't want to specify the name of the columns in the commands e.g i want to do something like this UPDATE any_view SET (SELECT * FROM any_view) = (SELECT * FROM another_ta