Re: [GENERAL] Get / Set Composite Type Fields within triggers

2013-06-24 Thread Ingmar Brouns
> My problem is inside triggers: How can I set or get type field values for > NEW or OLD? (I need it to check users permissions at row level, etc.) > > I tried NEW.((created).by), NEW.(created.by), NEW.created.by and nothing > works... > > Could you help me please? > > Thanks in advance. > Martin

[GENERAL] Get / Set Composite Type Fields within triggers

2013-06-24 Thread Martin Durao
Hi This is my first question, so, forgive me if it's a newby issue but I couldn't find an answer googling. I have a simple composite type CREATE TYPE info_base AS (by text, at timestamp without time zone); I want to use it as the data type of created, modified and deleted fields. I alread