On 31 Jan 2011, at 2:26pm, Samuel Adam wrote:
> On Mon, 31 Jan 2011 08:44:22 -0500, Simon Slavin <slav...@bigfraud.org>
> wrote:
>
>> On 31 Jan 2011, at 1:24pm, Samuel Adam wrote:
> [snip]
>>> Actually since this is an FTS3 table, the form with the quotes is the
>>> correct one. As Mr. da Silveira alluded later in his post, in FTS3, the
>>> row ID and only the row ID is an INTEGER
>>
>> But from his CREATE command, isn't the column called 'id' an alias to
>> the rowid ?
>
> FTS3 docs do not mention "id", as I quoted. Moreover, "id" is *not*
> normally an alias for rowid:
>
> sqlite> CREATE TABLE "Test" ("id" TEXT);
In the definition given in the original post, which I quoted, the table was
defined as follows:
> CREATE VIRTUAL TABLE Directors USING fts3(id INTEGER PRIMARY KEY NOT
> NULL, first_name TEXT NOT NULL, last_name TEXT NOT NULL,
> show_last_name_first INTEGER DEFAULT 0, normalised_name TEXT NOT NULL,
> sort_name TEXT NOT NULL, fanships_count INTEGER, image_url
> VARCHAR(255));
Under this situation, would SQLite not use 'id' as an alias to rowid ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
