On 04/18/2013 05:12 AM, Atri Sharma wrote:
On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso <aafonsoc@xxxxxxxxx> 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.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
