[sqlite] Handling the whole select query from an index

[Simon Slavin]

On 17 Sep 2015, at 1:13pm, Richard Hipp <drh at sqlite.org> wrote:

> At the end of the CREATE TABLE statement add keywords: "WITHOUT
> ROWID".  Like this:
> 
> CREATE TABLE postcode(
>  postcode TEXT,
>  long TEXT,
>  lat TEXT
> ) WITHOUT ROWID;

The documentation suggests that you need to explicitly declare a PRIMARY KEY, 
so you would need something more like

CREATE TABLE postcode(
 postcode TEXT PRIMARY KEY,
 long TEXT,
 lat TEXT
) WITHOUT ROWID;

but perhaps I misunderstood.

Simon.