Re: Emulating trigger BEFORE SELECT behavior

From: Alfonso Afonso <aafonsoc(at)gmail(dot)com>
To: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Emulating trigger BEFORE SELECT behavior
Date: 2013-04-18 12:05:32
Message-ID: B0F9EDC9-2711-4161-BC63-52F838880348@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Regards

El 18/04/2013, a las 08:54, Atri Sharma <atri(dot)jiit(at)gmail(dot)com> escribió:

> Hi all,
>
> I need a tool which allows me to do a task before every SELECT on a
> table. Specifically,the behavior I would get with a BEFORE SELECT
> trigger.
>
> Please advice me on this.
>
> Regards,
>
> Atri
>
> --
> Regards,
>
> Atri
> l'apprenant
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Alfonso Afonso
(personal)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Atri Sharma 2013-04-18 12:12:41 Re: Emulating trigger BEFORE SELECT behavior
Previous Message Daniel Verite 2013-04-18 11:53:04 Re: What's wrong with postgresql.org domain?