Re: [HACKERS] Re: [QUESTIONS] Arrays (inserting and removing)
Marc G. Fournier <scrappy@hub.org>
From: The Hermit Hacker <scrappy@hub.org>
To: "D'Arcy J.M. Cain" <darcy@druid.net>
Cc: pgsql-hackers@postgreSQL.org, pgsql-questions@postgreSQL.org
Date: 1998-01-15T18:42:51Z
Lists: pgsql-hackers
On Thu, 15 Jan 1998, D'Arcy J.M. Cain wrote: > > Actually, I use them quite extensively...I have several WWW-based > > search directories that are searched with: > > > > select oid,<fields> from <table> where <search conditions>; > > > > That display minimal data to the browser, and then if someone > > wants more detailed information, I just do: > > > > select * from <table> where oid = ''; > > But really there should be a proper key on this database. I think that > that's what Karl was getting at. If you need a unique ID number then > you should really create one and make it a unique index on the table. > This stuff was all built "pre unique index"...and we all know what its like to go in and "Rebuild" something that is already working :(