SunWuKung wrote:
I have a table with a sequence as its primary key.
On insert I would like to have all its fields (except the primary key)
default to the last one in the table (order by id desc limit 1).
I guess I should use a trigger to do this but I don't know how.
I'm not sure you can really change the DEFAULT clause with a trigger,
but you can get close.
You'll want a BEFORE INSERT trigger (in plpgsql).
Select into a variable of type RECORD your last row (... ORDER BY id
DESC LIMIT 1)
Update the values of the NEW variable where they are currently NULL.
Return NEW
Two points to consider:
1. Consider locking the table to prevent inserts while doing this.
Whether you need to do so depends on what you want to happen when two
inserts happen at the same time.
2. What happens if there is no previous row in the table?
--
Richard Huxton
Archonet Ltd
