PostgreSQL : query to find number of days different

June 19, 2010 – 12:07 pm  •  By admin  •  Posted in PostgreSQL, SQL

In my previous post about “MySQL: finding number of days different”, there is example of how to get number of days different from 2 date.  However, the SQL command is not valid for postgreSQL.  PostgreSQL does not support for the query syntax TO_DAYS().  Fortunately, there is alternative method to get number of days different with other syntax for PostgreSQL. Read More →

Apache, PHP and PostgreSQL Configuration

June 3, 2010 – 6:27 am  •  By admin  •  Posted in Apache, PHP, PostgreSQL

Installing and setup Apache, PHP and PostgreSQL are simple and straight forward.  However, the PostgreSQL library (libpg) or pgsql may not enabled or loaded even all Apache, PHP and PostgrSQL are properly installed.  There are a lot of information online, yet just doesn’t solve the problem that PostgreSQL libpg or pgsql is not loaded.  Some information online recommends some installation or setup packages for ALL in ONE that will install and setup Apache, PHP and PostgreSQL properly.  However, some (… like me) might dislike to use these installation packages that will also install some other files as well.  We will share on how to make all these three items; Apache, PHP and PostgreSQL to be setup and configured properly.
Read More →