Here's a high-level overview of what I want to do:

1.  A record in a postgresql database is changed. 
2.  If the change causes the data record to meet certain conditions based on   
    Boolean logic, a database trigger will invoke a Java UDF. 
3.  This Java UDF uses the JavaMail API to send an e-mail to a specified   

The javamailing program is written separately and is running fine.

Can any one give me the following details :

1.  Where to place the java or class file for access.
2.  plz give me the exact create function statements.
3.  plz give me the exact create trigger statments.  

             O R
Plz give me the code to satisfy my requirement.

Thanks in advance for ur help


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to