Trigger

From: soundar rajan <psrajan(at)yahoo(dot)com>
To: Mike Beller <beller(at)tradeworx(dot)com>, Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com>, pgsql-general(at)postgreSQL(dot)org
Cc: Thomas Reinke <reinke(at)e-softinc(dot)com>, Jose Soares <jose(at)sferacarta(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Trigger
Date: 1999-12-22 15:17:54
Message-ID: 19991222151754.19849.qmail@web2106.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to create a trigger. The function I'm
using returns the count(*) from a table. But, during
the creation of the trigger, I get an error stating
the function must return opaque. I tried the same
with the function to be returning a varchar. But,
again I get the same error.

In simple words, it's this. I'm trying to create a
simple trigger which just prints out a message (as
dbms_out.println() in oracle) before or after
insertion or updation on a table. Even if it doesn't
print a message, some changes to be made on the table.
Can some one give me a simple example which does it.

Thanks in advance.
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com

Browse pgsql-general by date

  From Date Subject
Next Message soundar rajan 1999-12-22 15:33:45 creating trigger
Previous Message Mike Beller 1999-12-22 14:55:56 Re: [GENERAL] copy command -- foiled by pg_atoi