Re: Emulating trigger BEFORE SELECT behavior

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Alfonso Afonso <aafonsoc(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Emulating trigger BEFORE SELECT behavior
Date: 2013-04-18 14:19:09
Message-ID: CAOeZVidUH1mfy=928OoteMAYb65JwLVtU_bhyPoRMbu7OidJGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-04-18 14:30:19 Re: Emulating trigger BEFORE SELECT behavior
Previous Message Adrian Klaver 2013-04-18 14:13:56 Re: Emulating trigger BEFORE SELECT behavior