UPDATE TRIGGER on view WAS: Re: Relation in tables

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема UPDATE TRIGGER on view WAS: Re: Relation in tables
Дата
Msg-id 20050216204358.M29214@narrowpathinc.com
обсуждение исходный текст
Ответ на Re: Relation in tables  (PFC <lists@boutiquenumerique.com>)
Ответы Re: UPDATE TRIGGER on view WAS: Re: Relation in tables  (PFC <lists@boutiquenumerique.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: Matching a column against values in code
Следующее
От: Geoffrey
Дата:
Сообщение: Re: Order of columns in a table important in a stored procedure?