SQLite Forum

Unique every N seconds. How?
Login
I want to define a table where identical entries (a combination of columns) within so many seconds apart are considered the same.

If, for example, I try:

`unique (col1,col2,dt between dt and datetime(dt,'+10 seconds'))`

(where `dt` is a date/time field)

I get an error: `expressions prohibited in PRIMARY KEY and UNIQUE constraints`

Fine. Is there some other way to achieve this?