Re: Syntax error in trigger

[Gabriella Pepe]

Well, I posted my question in the 'newbie' section (then it was moved), so I hoped someone with experience would teach me something I could not find myself.

The purpose of assigning even that query to a variable was simply readability (performance is unimportant in my context).

Of course, you were right: I added a right paren. I know an editor could find this kind of stupid things, but, as a developer (NOT a db expert in my case), I would really benefit from more detailed errors (if you search a little, eg. on StackOverflow, you can find #1064 errors for about anything...).

Finally, I replaced post_id with NEW.post_id.

The trigger compiled without errors, I hope it will work the way I imagined. :-)

Thanks very much for your time and patience