Hello,
I want to send mail on update of a field in a table.
I'm using pgmail() function (from sourceforge) . I'm
calling this function from another function which is
called by trigger on update of the field.
On executing the update statement i get error
CONTEXT: compile of PL/pgSQL function "pgmail" near
line 1
PL/pgSQL function "test" line 10 at assignment
The line 10 corresponds to the line where pgmail
function is called.
pos := pgmail(p1,p2,p3,p4);
Can anyone help me? I'm using postgres 7.4.7 version.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com