Hi,
What i am trying to do is
i have a join table eg
primarykey field1 field2
and based on SQL Select have the values of field1 inserted into a new table which will scroll which will launch a trigger but im having problems getting this to work? Any ideas anyone?
sql select may return 1 or more results so i will 1 insert statements
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html