Re: [GENERAL] cast record to array in plpgsql

2009-11-17 Thread Pavel Stehule
2009/11/17 Kurt : > dear list, > > i'm trying to implement a general logging scheme with a plpgsql-trigger. > The idea is, that after an update the trigger compares the elements of > OLD and NEW and logs the changes made to the record columns. the trigger > should be usable by any table, so the fie

[GENERAL] cast record to array in plpgsql

2009-11-17 Thread Kurt
dear list, i'm trying to implement a general logging scheme with a plpgsql-trigger. The idea is, that after an update the trigger compares the elements of OLD and NEW and logs the changes made to the record columns. the trigger should be usable by any table, so the field names are not known before