Re: Emulating trigger BEFORE SELECT behavior

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: Emulating trigger BEFORE SELECT behavior
Дата
Msg-id CAOeZVieyYidZ44SeWJGQrq8=a_7239oA=3XekHw6j9HG2DQzoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Emulating trigger BEFORE SELECT behavior  (Alfonso Afonso <aafonsoc@gmail.com>)
Ответы Re: Emulating trigger BEFORE SELECT behavior
Список 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 по дате отправления:

Предыдущее
От: Alfonso Afonso
Дата:
Сообщение: Re: Emulating trigger BEFORE SELECT behavior
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Emulating trigger BEFORE SELECT behavior