On Tue, Jan 19, 2010 at 08:08:19AM +0900, Charles Plessy wrote: > This is more or less what I meant by ???long??? format (in the sense of R???s > reshape() function). In order to fit this information in a SQL table, I was > more thinking about: > > package title text > package authors text > package published-in text > package year text > etc.
Hmmm, I'm not comfortable enough with R's reshape function, but I can tell that the 'package' stuff you was putting in front of the column definitions are not SQL conform. I was thinking of the package name as kind of a primary key. > In a previous discussion (which I can not find for the moment), there was no > objection to do the contrary: support only one reference. One reference per package is fine, makes things simple and supports my idea of using the package name as primary key. > The web sentinel has > currently the same limitation anyway. ... which is perfectly sufficient IMHO. > In the case a package contains multiple > programs to be cited with multiple articles, I was considering using a field > with a name like ???Reference-List-URL???, Sounds reasonable. Kind regards Andreas. -- http://fam-tille.de -- To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org