CODEWITHSUNDEEP
postgresqlgo
amanda45
amanda45

Reputation: 595

Db delete query always returns true

I am using golang with postgres. I want to delete users from my table by passing in the Id for that user. When I run the code below I always get true. Even when I pass in a ID that does not exist in the table. Is that normal? Does DB.Exec return err if the user ID is not in the database? 

func DeleteUser(ID int){
    err = nil
    _, err := DB.Exec("DELETE FROM Users WHERE user_id=$1", ID)

    if err == nil {

        return true
    }

    return false

}

Upvotes: 4

Views: 11378

Answers (1)

Tarun Lalwani
Tarun Lalwani

Reputation: 146510

Try this

func DeleteUser(ID int){
    err = nil
    res, err := DB.Exec("DELETE FROM Users WHERE user_id=$1", ID)

    if err == nil {

       count, err := res.RowsAffected()  
       if err == nil {
          /* check count and return true/false */
       }

    }

    return false

}

Upvotes: 10

Related Questions