Skip site navigation (1) Skip section navigation (2)

Re: Trigger and Trigger function, Part 2

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Matt Iskra <Matt(dot)Iskra(at)doj(dot)ca(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trigger and Trigger function, Part 2
Date: 2005-06-17 17:39:57
Message-ID: d8bf3b45298b27137fd7ba7d2efb2cf7@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group