diff options
Diffstat (limited to 'internal/db/pg')
| -rw-r--r-- | internal/db/pg/pg.go | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/internal/db/pg/pg.go b/internal/db/pg/pg.go index 64d6fb636..f352404aa 100644 --- a/internal/db/pg/pg.go +++ b/internal/db/pg/pg.go @@ -223,7 +223,12 @@ func (ps *postgresService) GetWhere(where []db.Where, i interface{}) error { q := ps.conn.Model(i) for _, w := range where { - q = q.Where("? = ?", pg.Safe(w.Key), w.Value) + if w.CaseInsensitive { + q = q.Where("LOWER(?) = LOWER(?)", pg.Safe(w.Key), w.Value) + } else { + q = q.Where("? = ?", pg.Safe(w.Key), w.Value) + } + } if err := q.Select(); err != nil { @@ -1143,7 +1148,6 @@ func (ps *postgresService) GetNotificationsForAccount(accountID string, limit in q := ps.conn.Model(¬ifications).Where("target_account_id = ?", accountID) - if maxID != "" { n := >smodel.Notification{} if err := ps.conn.Model(n).Where("id = ?", maxID).Select(); err != nil { |