Thread: Question for postgreSQL

Question for postgreSQL

From
Miljan Jeremić
Date:
Dear Sir's,
I have one problem with type trigger in example:

CREATE FUNCTION emp_stamp() RETURNS trigger AS '
    ....
How to create type triger for this function?
How create type for function that returned primary key, in pd AdminII
function is check_primary_key().

Thank You




Re: Question for postgreSQL

From
Darko Prenosil
Date:
On Wednesday 24 March 2004 15:27, Miljan Jeremić wrote:
> Dear Sir's,
> I have one problem with type trigger in example:
>
> CREATE FUNCTION emp_stamp() RETURNS trigger AS '
>     ....
> How to create type triger for this function?
> How create type for function that returned primary key, in pd AdminII
> function is check_primary_key().
>
    You don't need to create any type for trigger procedures. From inside of
trigger procedure You can acces two rows(tuples): NEW and OLD, and Your
trigger function must RETURN NEW if you want to allow data changes, or OLD if
You want to discard changes.
Also, this is more pgsql-hackers@postgresql.org kind of question...

 See: http://www.postgresql.org/docs/7.4/interactive/plpgsql-trigger.html


Regards !
(Pozdrav !)