[sqlite] Use of strftime in a CREATE INDEX sintax.

[Danilo Cicerone]

Hi to all,
I'm trying to create an index as follow:

CREATE TABLE FattureCli
(
   fat_id INTEGER PRIMARY KEY,
   fat_rif_sogid INTEGER DEFAULT NULL,
   fat_rif_mpaid INTEGER DEFAULT NULL,
   fat_numfat INTEGER NOT NULL, -- It would be unique by year;
   fat_datfat CHAR(10) NOT NULL, -- YYYY-MM-DD;
   fat_datter CHAR(10) NOT NULL,
   fat_datpag CHAR(10) NOT NULL,
   fat_totfat REAL DEFAULT 0,
   fat_caufat VARCHAR(100) NOT NULL,
   fat_stapag CHAR(2) NOT NULL DEFAULT 'Si',
   fat_note TEXT NOT NULL
);
CREATE UNIQUE INDEX Numerazione ON FattureCli (fat_numfat, strftime('%Y',
fat_datfat)) ON CONFLICT FAIL;

Could it be translated into a corret sintax without add another field
(fat_year)?

Thanks in advance, Danilo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users