indu ss <ind1_us(at)yahoo(dot)com> writes:
> 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
Uh, you didn't show us the actual error, nor the problematic line
within pgmail. (The reference to function "test" is just a stack
back-trace of how you got to pgmail; it does not imply that that's
where the error is.)
regards, tom lane