pgsql differs from mysql
Wednesday, May 27th, 2009i have decided to build the a sample application using jmatter on top of postgres database i just changed the nepali/english calendar thing into postgress so much of changes almost took a day. postgres have more defined type of data type then mysql, like in mysql you could be doing concat(1,2) but in pg you cannot concat integers with concat rather the concat operator is || and you need to do select 1::varchar||2::varchar . guess it :: is the type conversion operator.
and when we do select a b from table1 then it is wrong the field a is not aliased into b we need to select a as b from table1.
i will up2date as i go on