CREATE OR REPLACE FUNCTION updateWebTransLog() RETURNS TRIGGER AS '
DECLARE
transactionType character varying(3);
BEGIN
INSERT INTO webtranslog(username,reqtime,transactiontype,descr iption) (SELECT tellerid,date,'CR', mbnumber FROM userreg WHERE mbnumber = NEW.mbnumber);
RETURN NULL;
END;

' LANGUAGE plpgsql;




ifollowing is th output::


ERROR: syntax error at or near "CR"
LINE 5: ...ansactiontype,description) (SELECT tellerid,date,'CR', mbnum...
^


********** Error **********

ERROR: syntax error at or near "CR"
SQL state: 42601
Character: 220



please help!!

This error occurs because you are nesting single quotes.

Quote from the manual for the CREATE FUNCTION statement regarding the function body:
For details on how to use the dollar quotings, read the mentioned section:

http://www.postgresql.org/docs/9.0/s...DOLLAR-QUOTING

I tried it and it worked. Very thankful to u... shammat