2008/11/20 Christophe Leske <[EMAIL PROTECTED]>: > Hi, > > i am creating my table as such: > > create temp table idlookup as select id from ... > > I would like ID to be unique in my idlookup table. How would I do this > using this construct?
create temp table idlookup as select distinct id from ... create unique index idlookup_index on idlookup( id ); Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users