Re: Emulating trigger BEFORE SELECT behavior

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Alfonso Afonso <aafonsoc(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Emulating trigger BEFORE SELECT behavior
Date: 2013-04-18 12:12:41
Message-ID: CAOeZVieyYidZ44SeWJGQrq8=a_7239oA=3XekHw6j9HG2DQzoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso <aafonsoc(at)gmail(dot)com> wrote:
> Hi Atri
>
> Maybe you could think different and, instead of do a "before select trigger", you can:
>
> - create a store procedure with result is a recordset
> - create a view
>
> If you can't... could you please explain us a bit more about the requirements about this before action?
>
> Good luck

Hi Alonso,

Sure, I will try that out.

The before operation shall get the values of all the columns of the
queried table, convert them to a string and insert the string into a
different table.Then, the SELECT query shall proceed as before.

Regards,

Atri

--
Regards,

Atri
l'apprenant

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-04-18 13:21:21 Re: Emulating trigger BEFORE SELECT behavior
Previous Message Alfonso Afonso 2013-04-18 12:05:32 Re: Emulating trigger BEFORE SELECT behavior