Re: Emulating trigger BEFORE SELECT behavior

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: Emulating trigger BEFORE SELECT behavior
Дата
Msg-id CAOeZVifuoQP3mS20JL5NQZK_BJ8aV-+EWJQX2KcO7iG0dwok5Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Emulating trigger BEFORE SELECT behavior  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Emulating trigger BEFORE SELECT behavior
Re: Emulating trigger BEFORE SELECT behavior
Список pgsql-general
> How about a RULE:
>
> http://www.postgresql.org/docs/9.2/interactive/sql-createrule.html
>
> Rules can be tricky, so I would at least skim through:
>
> http://www.postgresql.org/docs/9.2/interactive/rules.html

Thanks.

It looks like that it is another way to create a view, which is
probably not I want(I need to store some data per SELECT query in
another table).

One way I was thinking of was creating an updatable view, which is
initialized to NULL. As SELECT queries take place, I can update the
view to include the new rows.

What say?

Atri



--
Regards,

Atri
l'apprenant


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

Предыдущее
От: "ascot.moss@gmail.com"
Дата:
Сообщение: Re: How to build my own 9.2.4 installer package for IBM Power System ppc64
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Emulating trigger BEFORE SELECT behavior