Skip site navigation (1) Skip section navigation (2)

how to get trigger start function not procedure

From: chris Gnther <guenther(at)uscreen(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to get trigger start function not procedure
Date: 2000-12-29 16:23:55
Message-ID: 20001229172355.35646b1c.guenther@uscreen.de (view raw or flat)
Thread:
Lists: pgsql-novice
Hi folks,

my name is chris and I'm pretty new to pSQL.
I used to work with MS SQL Server 6.5 and have
some problems adjusting myself with pSQL. 

Now my question. As mentioned in the subject I 
want a trigger to fire an sql-function - not a 
c procedure - although this would be much cooler. 
I'm trying to get something to work I always did 
with MS SQL. When a dataset is inserted in a 
table I want a trigger to be fired to set the 
creation-date and -time plus the user and a trigger
setting the update-date -time and user. 

Does anyone has any idea of how to do this with pSQL???

In MS SQL server i just created a trigger with the 
necessary SQL-commands inside the trigger but in pSQL
it seems that trigger just start procdures.

	thanks in advance

		chris

--

Responses

pgsql-novice by date

Next:From: chris GntherDate: 2000-12-29 16:48:41
Subject: how to get last inserted id
Previous:From: John BurskiDate: 2000-12-29 16:12:05
Subject: Re: date_part function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group