title: affected rows in postgres with CodeIgniter
body: <p>I have a following query:</p>
  
  <blockquote>
    <p>UPDATE "user" SET "first_name" = 'abc', "last_name" = '', "mobile" = '988988888', "comment" = 'Hello' WHERE "id" = '15'</p>
  </blockquote>
  
  <p>and above data is already in db. means i submit form without changing any data.</p>
  
  <p>I hit above query in terminal and it says : <code>UPDATE 1</code></p>
  
  <p><code>CI CODE:</code></p>
  
  <pre><code>$query = $this-&gt;db-&gt;get_where('user',array('id'=&gt;$id),1);
  if ($query-&gt;num_rows() &gt; 0)
  {
      $this-&gt;db-&gt;update('user', $data, array('id'=&gt;$id));         
      echo $afftected_rows = $this-&gt;db-&gt;affected_rows();exit;
  }
  </code></pre>
  
  <p><code>DB SCHEMA(export using psql cmmand)</code></p>
  
  <pre><code>CREATE TABLE "user" (
    id integer NOT NULL,
    first_name character varying(50),
    last_name character varying(50),
    mobile character varying(50),  
    comment character varying(500)
  );
  </code></pre>
  
  <p>so what is the problem? why it is return 1, even if i don't change any data. is this the normal behaviour for postgres?</p>