Re: Function Won't Compile

Eric Chacon wrote:
>
> I'm sure I'm doing something stupid, but this is driving me nuts...
>
> This is the first stored procedure I've ever written in my life.

You're close, debugging plpgsql can be tricky:

> DROP FUNCTION update_flag_func();
> CREATE FUNCTION update_flag_func()
> RETURNS text
> AS 'UPDATE update_flag SET content=current_timestamp;'
> LANGUAGE 'plpgsql';
>
> SELECT update_flag_func();
>

> psql:udt:7: NOTICE: plpgsql: ERROR during compile of update_flag_func
> near line 1
> psql:udt:7: ERROR: parse error at or near "UPDATE"

You need a couple of things (untested):

... AS '
BEGIN
UPDATE update_flag SET content=current_timestamp;
RETURN ''OK'';
END;
' LANGUAGE 'plpgsql';

The BEGIN...END wrapper is needed as is a value to RETURN. There is an
example of this function in my PostgreSQL Notes at http://techdocs.postgresql.org/

HTH

- Richard Huxton