UPDATE TRIGGER on view WAS: Re: Relation in tables - Mailing list pgsql-sql

On Wed, 16 Feb 2005 19:56:25 +0100, PFC wrote
> [snip] Use UPDATE triggers on the 
> views, which in fact  write to the products table [snip]

You can DO that!?!

Are you saying that a client can DELETE or INSERT or UPDATE a view and through
a trigger you can make this happen?  Way cool.  Can you provide a simple example?

And all this time I thought that you couldn't write to a view.

Kind Regards,
Keith