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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html