On Fri, 17 Sep 2010, Igor Tandetnik wrote: > To: sqlite-users@sqlite.org > From: Igor Tandetnik <itandet...@mvps.org> > Subject: Re: [sqlite] UNIQUE PRIMARY KEY on TEXT column? > > Keith Roberts <ke...@karsites.net> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
