CREATE OR REPLACE FUNCTION msgTrigger() RETURNS "trigger" AS
$BODY$
BEGIN
IF  NEW.'mailbox_idnr' = 
(
SELECT 'dbmail_mailboxes'.'mailbox_idnr' 
FROM 'dbmail_mailboxes' 
WHERE 'dbmail_mailboxes'.'owner_idnr' = 
     (SELECT 'dbmail_mailboxes'.'owner_idnr' 
      FROM 'dbmail_mailboxes' WHERE 
      'dbmail_mailboxes'.'mailbox_idnr' = 
      NEW.'mailbox_idnr') 
AND 'dbmail_mailboxes'.'name' = 'spam'
) THEN
INSERT INTO spamTriggerTable ('id', 'user_idnr', 'message_idnr', 'mailbox_idnr', 'frm', 'subj', 'to', 'wait_msg', 'date')
      VALUES (
              NULL, 
              (SELECT 'dbmail_mailboxes'.'owner_idnr' FROM 'dbmail_mailboxes' WHERE 'dbmail_mailboxes'.'mailbox_idn'r = NEW.'mailbox_idnr'),
              NEW.message_idnr,
              NEW.mailbox_idnr,
              (SELECT 'dbmail_headervalue'.'headervalue' FROM 'dbmail_headervalue' WHERE 'dbmail_headervalue'.'physmessage_id' = NEW.'physmessage_id' AND 'dbmail_headervalue'.'headername_id' = '3'),
              (SELECT 'dbmail_headervalue'.'headervalue' FROM 'dbmail_headervalue' WHERE 'dbmail_headervalue'.'physmessage_id' = NEW.'physmessage_id' AND 'dbmail_headervalue'.'headername_id' = '7'),
              (SELECT 'dbmail_headervalue'.'headervalue' FROM 'dbmail_headervalue' WHERE 'dbmail_headervalue'.'physmessage_id' = NEW.'physmessage_id' AND 'dbmail_headervalue'.'headername_id' = '8'),
              (SELECT 'dbmail_headervalue'.'headervalue' FROM 'dbmail_headervalue' WHERE 'dbmail_headervalue'.'physmessage_id' = NEW.'physmessage_id' AND 'dbmail_headervalue'.'headername_id' = '8'),
              NULL
             );
RETURN NEW;
END IF;
RETURN NULL; -- result is ignored since this is an AFTER trigger
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;