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

From Atri Sharma
Subject Re: Emulating trigger BEFORE SELECT behavior
Date
Msg-id CAOeZVieyYidZ44SeWJGQrq8=a_7239oA=3XekHw6j9HG2DQzoQ@mail.gmail.com
Whole thread Raw
In response to Re: Emulating trigger BEFORE SELECT behavior  (Alfonso Afonso <aafonsoc@gmail.com>)
Responses Re: Emulating trigger BEFORE SELECT behavior
List pgsql-general
On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso <aafonsoc@gmail.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


pgsql-general by date:

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