X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0C4848BA28C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Feb 2005 13:44:49 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 45353-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Feb 2005 13:44:44 +0000 (GMT)
Received: from benhur.intern.intend.de (intern.intend-online.de
 [80.69.207.98])
	by svr1.postgresql.org (Postfix) with ESMTP id 71EE98BA2B9
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2005 13:44:41 +0000 (GMT)
Received: from thuja ([192.168.100.173])
	by benhur.intern.intend.de (8.12.8p1/8.12.6/Benhur 8.12.6) with SMTP id
	j1GDiWM2030759
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2005 14:44:32 +0100
From: "Eugen Gass" <gass@intend.de>
To: <pgsql-sql@postgresql.org>
Subject: Trigger
Date: Wed, 16 Feb 2005 14:44:30 +0100
Message-ID: <LKEAIFJAEICHBHJOIFOCIEBPCAAA.gass@intend.de>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Importance: Normal
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200502/174
X-Sequence-Number: 20285

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