[GENERAL] [PL/pgSQL] function call

2011-10-31 Thread Tarlika Elisabeth Schmitz
I have created a function log_insert(), which is simply a shorthand for an INSERT table and which I want to call from various trigger functions. CREATE OR REPLACE FUNCTION log_insert(vseverity text, vtrigger text, vtriggertable text, vtriggerid text, vmessage text) RETURNS boolean AS $BODY$ BEGIN

Re: [GENERAL] [PL/pgSQL] function call

2011-10-31 Thread Merlin Moncure
On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz postgres...@numerixtechnology.de wrote: I have created a function log_insert(), which is simply a shorthand for an INSERT table and which I want to call from various trigger functions. CREATE OR REPLACE FUNCTION log_insert(vseverity

Re: [GENERAL] [PL/pgSQL] function call

2011-10-31 Thread Pavel Stehule
2011/10/31 Merlin Moncure mmonc...@gmail.com: On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz postgres...@numerixtechnology.de wrote: I have created a function log_insert(), which is simply a shorthand for an INSERT table and which I want to call from various trigger functions.

Re: [GENERAL] [PL/pgSQL] function call

2011-10-31 Thread Tarlika Elisabeth Schmitz
On Mon, 31 Oct 2011 09:41:40 -0500 Merlin Moncure mmonc...@gmail.com wrote: On Mon, Oct 31, 2011 at 8:31 AM, Tarlika Elisabeth Schmitz postgres...@numerixtechnology.de wrote: I have created a function log_insert(), which is simply a shorthand for an INSERT table and which I want to call from