That is what I use now, together with the select as Hick mentioned.
An other version I played with is two indexes, one unique on (id,
ts_from) to find the last version if eol is not null and one unique on
(id, ts_eol) where eol = null to find the current active version of id.
Beware that in
On 21-6-2019 11:46, Simon Slavin wrote:
> You will note that SQLite is perfectly happy with
>
> CREATE UNIQUE INDEX idx_test_c
>ON test(id, ts_from, ts_eol)
> WHERE ts_eol = NULL
> ;
That is what I use now, together with the select as Hick mentioned.
An other version I played with is two ind
On 21 Jun 2019, at 10:29am, ingo wrote:
> Is this because max() is not deterministic,
> or because current_timestamp is not,
> or both?
The max(). For the reason you identified: it would have to recalculate the
index values for all rows in the table every time any of the rows changed. You
wi
Found the answer!!! :D
change this query
by this query
INSERT INTO users(user,pass,name,email)
VALUES('root',md5("root"),'Root',' [EMAIL PROTECTED]');
and works very well
INSERT INTO users(user,pass,name,email) VALUES('root',(select
md5("root")),'Root',' [EMAIL PROTECTED]');
thanks to all
On
4 matches
Mail list logo
