On Fri, 17 Sep 2010, Igor Tandetnik wrote: > To: [email protected] > From: Igor Tandetnik <[email protected]> > Subject: Re: [sqlite] UNIQUE PRIMARY KEY on TEXT column? > > Keith Roberts <[email protected]> wrote: >> I think what I really mean is I want a text column with only >> one unique value, that is also indexed. > > UNIQUE constraint will do just that. > >> Also ,I guess the INTEGER PRIMARY KEY column is worth >> keeping in the table, as a matter of course? > > Usually, yes.
Thanks Igor. I'm getting there now ;) Keith ----------------------------------------------------------------- Websites: http://www.karsites.net http://www.php-debuggers.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] ----------------------------------------------------------------- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
