Re: Emulating trigger BEFORE SELECT behavior

On 04/18/2013 05:12 AM, Atri Sharma wrote:
> 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.

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

>
> Regards,
>
> Atri
>
> --
> Regards,
>
> Atri
> l'apprenant
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com