Search Postgresql Archives

Get / Set Composite Type Fields within triggers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 already know hot to index, update and select a sub-field like

CREATE INDEX ix_created_by ON xxx.yyy ((created).by);
UPDATE xxx.yyy SET created.by = 'user';
select * from xxx.yyy where (created).by = 'that user';

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux