UPDATE pg_proc SET prosrc='SQL statement' WHERE proname LIKE
'functionname';
seems to work for SQL queries at least. I doubt it's recommended,
though!
Moray
----------------------------------------------------------------------
----------------
Moray.McConnachie@computing-services.oxford.ac.uk
----- Original Message -----
From: Sascha Ziemann <szi@khs-ag.de>
To: <pgsql-general@postgreSQL.org>
Sent: Thursday, December 02, 1999 11:39 AM
Subject: [GENERAL] ALTER FUNCTION
> Hi,
>
> are there plans for an ALTER FUNCTION statement for Postgresql? I
> think functions are completely unuseable, when it is not possible to
> change the definition of a function. A bugfix in a function
requires
> the export of all data, a redefinition of the function and a
complete
> reimport. Or is there a simpler way?
>
> Sascha
>
> ************
>
>