title: SQL postgresql insert statement
body: <p>I have a following question, for example I have a following table:</p>
  
  <pre><code>CREATE TABLE "regions" (gid serial PRIMARY KEY,
  "__gid" int8,
  "name" varchar(20),
  "language" varchar(7),
  "population" int8);
  </code></pre>
  
  <p>And I want to insert some records, say one of the values for "name" is - 'B', what sort of code would I have to write to change 'B' to 'English-Speaking'? Is that done with some sort of trigger? So would I have to write a trigger to change the values automatically on insert? Any help greatly appriciated!!!</p>