Thank you, this done the job.All the best
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Firing-trigger-if-only-tp5798484p5799344.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postg
On Thu, Apr 3, 2014 at 8:50 AM, Gabriel wrote:
> Good afternoon all.I have some problem with triggers on PostgreSQL 8.4.I
> have
> a trigger on specific table(articles) that fires on update statement:
>
> CREATE OR REPLACE FUNCTION trigger_articles_update()
> RETURNS trigger AS
> $BODY$BEGIN
>
Good afternoon all.I have some problem with triggers on PostgreSQL 8.4.I have
a trigger on specific table(articles) that fires on update statement:
CREATE OR REPLACE FUNCTION trigger_articles_update()
RETURNS trigger AS
$BODY$BEGIN
INSERT INTO
article_change(article_id,change_type)VALUES(