How to catch database operation errors

I think I'm strugling over some basic missunderstanding.

The following, in my case, always returns true. Even it was not able to delete it.
But why?
From my point of view it should only return true if the record has been deleted.

PHP Code:

$result = $this->db->delete('users');