diff options
Diffstat (limited to '')
| -rw-r--r-- | internal/database/migrations.go | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/database/migrations.go b/internal/database/migrations.go index cfc1159d..d40e5d2f 100644 --- a/internal/database/migrations.go +++ b/internal/database/migrations.go @@ -876,4 +876,10 @@ var migrations = []func(tx *sql.Tx) error{ _, err = tx.Exec(sql) return err }, + func(tx *sql.Tx) (err error) { + // the WHERE part speed-up the request a lot + sql := `UPDATE entries SET tags = array_remove(tags, '') WHERE '' = ANY(tags);` + _, err = tx.Exec(sql) + return err + }, } |