On 11 Feb 2017, at 14:50, Rob van der sloot wrote: > I want to use the index of a specific column of a table as a pulldown list > in my application.
Wouldn't SELECT DISTINCT column FROM table; give you the same effect? I expect the query planner would use the table or not according to its estimate of the benefit of doing so. Best regards, Niall O'Reilly _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
