On Sat, 2005-01-08 at 00:04 -0500, John Richard Moser wrote: > What can be in an SQL table?
Tuples. > Can tables contain tables? Thankfully not. > I want to be able to search for a given > package and find what files are in it, search for a file and find what > packages supply it. . . what's the best way to do this? CREATE TABLE data (package TEXT, file TEXT); SELECT file FROM data WHERE package='desired'; SELECT package FROM data WHERE file='desired'; Note that indexes are probably desired. > All content of all messages exchanged herein are left in the > Public Domain, unless otherwise explicitly stated. It may be your right to put your comments in the public domain, but it is not your right to put my comments in the public domain.
