Re: trigger question

On Tue, Aug 16, 2005 at 07:19:38PM -0500, Apu Islam wrote:
> I have a trigger which is not working properly.
> The error I get is parse error at $1. I am putting the code here for
> someone to see and comment on.

When do you get the error?  When you create the function, or when
the trigger calls it?  What version of PostgreSQL are you using?

>                 INSERT INTO customer_stat VALUES (
> ''NEW.cisconasport'',NEW.h323connecttime,hour,0,0,0,0,0,''p$

The above INSERT command looks odd.  Why do you quote NEW.cisconasport?
Where does the last pair of single quotes having a closing pair?
Where are the closing parenthesis and statement-terminating semicolon?

--
Michael Fuhr