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

From Atri Sharma
Subject Re: Emulating trigger BEFORE SELECT behavior
Date
Msg-id CAOeZVidUH1mfy=928OoteMAYb65JwLVtU_bhyPoRMbu7OidJGA@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
List pgsql-general
>
> So what would you run the SELECT against, another view or table?

No, what I meant was:

SELECT on main table: fires a rule which updates a view V1

Now, essentially, view V1 has the data I was trying to acquire
originally through BEFORE INSERT trigger.

When I need the data, I can query view V1.

Atri


--
Regards,

Atri
l'apprenant


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Emulating trigger BEFORE SELECT behavior
Next
From: Adrian Klaver
Date:
Subject: Re: Emulating trigger BEFORE SELECT behavior