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.
Power Tools for PostgreSQL
In response to
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!|