On 7 Dec 2000, at 1:59, Adam Haberlach wrote: > I'm looking for a generalized way to set a field to 'now' > whenever a record is updated. > > First, I started creating a plpgsql function for each table that > I needed this for, and then using a trigger. > > Later, I realized that the functions were all identical, so I > created one function, which lukily was always updating a field > with the same name. > > I'm looking for a way to specify a field name when I create the > trigger, so I can have one function and assign it to any table > with any timestamp field and have it update automagically. > I can't seem to get a parameter into the function. Any ideas? There's stuff in contrib/spi that handles this (IIRC, a C function called moddatetime or something like that.) It allows you to specify a fieldname of the datetime field, I believe. Plus, this should be (slightly?) faster that a PLSQL routine. -- Joel Burton, Director of Information Systems -*- [EMAIL PROTECTED] Support Center of Washington (www.scw.org)
