Trigger - Mailing list pgsql-sql

From Eugen Gass
Subject Trigger
Date
Msg-id LKEAIFJAEICHBHJOIFOCIEBPCAAA.gass@intend.de
Whole thread Raw
Responses Re: Trigger  (Michael Fuhr <mike@fuhr.org>)
Re: Trigger  (Pavel Rabel <pavel@sajt.cz>)
List pgsql-sql
Hi,

I'm trying to create a trigger on PostgreSQL

it should be like an oracle(sql) sample code:

create or replace trigger frei_polygon_sync
after INSERT on frei_polygon
Referencing NEW as newROW
for each row
Begin:newRow.objektid :=  :newRow.gid;:
end;

Can sombody help me to do the same on Postrgres

Thanks 

Best Regards

EG


pgsql-sql by date:

Previous
From: "Simon Kinsella"
Date:
Subject: GROUPing only those rows that do not contain a NULL field?
Next
From: patrick
Date:
Subject: how to select custom value when exists otherwise select default