title: postgresql insert null value on query
body: <p>In my php code query, i got some error when i will place a null value 
  into the table. The column names "number1","number2", and "number3" are integers and can have a null value. </p>
  
  <p>if there is no null value, the query works</p>
  
  <p>query is like this
   <strong>insert into table(number1,number2,number3) values (1,2,3);</strong></p>
  
  <p>but when I leave a blank value on the input form on the PHP, </p>
  
  <p>for example I will not place value for column "number2", the query will look 
  like this.  </p>
  
  <p><strong>insert into table(number1,number2,number3) values (1,,3);</strong></p>
  
  <p>it says ERROR: syntax error at or near ","
  SQL state: 42601</p>
  
  <p>Does anybody have an idea how to solve this?</p>
  
  <p>this query is likely to be the solution but is there any other way?
  <strong>insert into table(number1,number2,number3) values (1,null,3);</strong></p>
  
  <p>because i got so many variables like that and am a bit lazy to place some conditions like when that variable returns a blank value then value="null"</p>