Dynamic update of a date field
От | Musial, Jan (GIUB) |
---|---|
Тема | Dynamic update of a date field |
Дата | |
Msg-id | 9255BE145568B443A366804DA0BA275F1BF22B29@aai-exch-mbx4.campus.unibe.ch обсуждение исходный текст |
Ответы |
Re: Dynamic update of a date field
Re: Dynamic update of a date field |
Список | pgsql-general |
Dear all, I have a question concerning default value/trigger function which supposed to update/fill field called time_stamp whenevera row is inserted. Let say that we have a table: CREATE TABLE dummy (year smallint,month smallint,day smallint,time_stamp date); I would like to update "time_stamp" dynamically without knowledge of a table name and using the values placed in the columns:year,month,day. The trick is that I have ~2000 tables which I populate with some time information, so either I couldsomehow fetch it to_timestamp() function in the Default definition of the field (while creating a table) or create atrigger function which doesn't require the table name (or retrieve it dynamically) and which is executed whenever a rowis added to any table. As I am new to postgres/plpgsql any suggestions are more than welcome. Thank you in advance, Jan Musial
В списке pgsql-general по дате отправления: