On Jul 17, 2012, at 20:59, Mohd Shaiza Ibrahim <mohdshaiza@xxxxxxxxx> wrote: > Hi, > > Can you guys please help me? My question sounds like this. > > When I insert a new record in a table, can I create a trigger to add > another record based on the inserted record in the same table? > > For example, > > INSERT INTO employee (emp_id, emp_name) VALUES (0001, 'Jack'); > > The result: > > Select * from employee; > > emp_id | emp_name > 0001 | Jack > 0002 | Bob > > I've tried running the statement below but it doesn't work. Infinite > loop i'm guessing. > > Infinite loop is correct. You need to fix your logic to solve that problem or consider a new design. Maybe restrict inserts to the table to a security definer function and put you dual insert logic into it. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
