Re: Function to set up variable inside it

Hi Guys,

thank you for your help !

Hmm yes something like this.

I was wondering if is possible to pass variable into function:

CREATE FUNCTION change_trigger() RETURNS trigger AS $$

BEGIN

IF TG_OP = 'INSERT'

THEN

INSERT INTO logging.t_history (tabname,
schemaname, operation, new_val)

VALUES (TG_RELNAME, TG_TABLE_SCHEMA,
TG_OP, row_to_json(NEW));

RETURN NEW;

ELSIF TG_OP = 'UPDATE'

THEN

INSERT INTO logging.t_history (tabname,
schemaname, operation, new_val, old_val)

VALUES (TG_RELNAME, TG_TABLE_SCHEMA, TG_OP,

row_to_json(NEW), row_to_json(OLD));

RETURN NEW;

ELSIF TG_OP = 'DELETE'

THEN

INSERT INTO logging.t_history (tabname,
schemaname, operation, old_val)

VALUES (TG_RELNAME, TG_TABLE_SCHEMA,
TG_OP, row_to_json(OLD));

RETURN OLD;

END IF;

END;

$$ LANGUAGE 'plpgsql' SECURITY DEFINER;

Best,
Jacek

2018-05-15 14:58 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 05/15/2018 05:28 AM, Łukasz Jarych wrote:
>
>> Hi Guys,
>>
>> I am using postgres 10.3 (or 4?).
>> IT is possible to set up variable inside function?
>>
>
> Like this?:
>
> https://www.postgresql.org/docs/10/static/plpgsql-declarations.html
>
>
>> Best,
>> Jacek
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>