Joris Dobbelsteen wrote: >> >> CREATE TABLE attendance >> ( >> attendanceid serial primary key, > > Why you have this??? You already have (entered,timeperiod,studentid) > that you can use, since that must be unique too. Try to avoid surrogate > keys as much as possible (it really increases performance and > ease-of-writing for complex queries!
Correct me if I am wrong, but wouldn't a simple number be a lot easier to look up than a composite key? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings