[postgis-users] Trigger

[Don Drake]

Check out the docs:

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

-Don


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Eugen
Gass
Sent: Wednesday, February 16, 2005 8:55 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Trigger


Hi,

I'm trying to create a trigger on PostgreSQL+PostGIS

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 please to do the same on Postrgres

Thanks 

Best Regards

EG
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users