indu ss <ind1_us@xxxxxxxxx> 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
