Re: problem with plpgsql trigger function: parse error near ""

"Yudie@axiontech.com" wrote:
> 
> I just tried the trigger function from:
> http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html
> (You can read the sql command on the bottom of this message.)

There have been issues with carriage-returns in PL/pgSQL. If you
cut'n'pasted that from the HTML into some file or directly into a psql
prompt, you likely got bitten by that.

Try to put the content into a file and make sure that is only has
linefeeds.
   vi   <cut'n'paste>   :set notextmode   :wr filename   :q   psql dbname <filename


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #