Re: Emulating trigger BEFORE SELECT behavior - Mailing list pgsql-general

From Atri Sharma
Subject Re: Emulating trigger BEFORE SELECT behavior
Date
Msg-id CAOeZVifuoQP3mS20JL5NQZK_BJ8aV-+EWJQX2KcO7iG0dwok5Q@mail.gmail.com
Whole thread Raw
In response to Re: Emulating trigger BEFORE SELECT behavior  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Emulating trigger BEFORE SELECT behavior
Re: Emulating trigger BEFORE SELECT behavior
List 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 by date:

Previous
From: "ascot.moss@gmail.com"
Date:
Subject: Re: How to build my own 9.2.4 installer package for IBM Power System ppc64
Next
From: Adrian Klaver
Date:
Subject: Re: Emulating trigger BEFORE SELECT behavior