Firing triggers based on certain Insert conditions

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Firing triggers based on certain Insert conditions
Date: 2007-01-28 18:12:47
Message-ID: d86a77ef0701281012r74a2a446i8a529119026fa046@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
I have a table in which i have a field named 'source'
A trigger is written on this table.
I want this trigger to fire only when after Insert this field 'source'
has value = 'from', otherwise trigger should not be fired at all.
Just wondering if its really possible?

Thanks in advance.
Harpreet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anton Melser 2007-01-28 18:18:23 Re: Questions about horizontal partitioning
Previous Message Tom Lane 2007-01-28 18:11:41 Re: [GENERAL] Password issue revisited