On Jun 17, 2005, at 12:37 PM, Matt Iskra wrote:

> However, PostgreSQL is STILL giving me a syntex error on line two of 
> the above function. The exact text is:
>
>   ERROR: syntax error at or near "FUNCTION" at character 16.


The function as written works for me. I don't think it is a missing 
schema error because in that case you would see a different error. My 
best guess is there is some kind of invisible bad character there. Try 
this: put the cursor in front of 'oc.' and backspace until it is next 
to 'FUNCTION'. Then hit one space and try again.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

• Trigger and Trigger function, Part 2 at 2005-06-17 16:37:23 from Matt Iskra

pgsql-novice by date

Next:	From: John DeSoi	Date: 2005-06-17 19:05:23
	Subject: Re: Trigger and Trigger function, Part 3 - success!
Previous:	From: Matt Iskra	Date: 2005-06-17 17:32:53
	Subject: Trigger and Trigger function, Part 3 - success!