Archive for the ‘PostgreeSQL’ Category
Porting applications from Oracle to PostgreSQL
If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle [...]
Tags: Oracle PostgreSQL
Posted in: Oracle, PostgreeSQL
| 
July 30, 2010
Alexandru Gyulai
| 
3 Comments
Extending PostgreSQL – A better CONCAT operator
PostgreSQL users have the option of extending the set of functions and operators available. If you have a common SQL or programmatic routine, custom functions can be an effective way to more succinctly and efficiently accomplish your tasks. Likewise, custom operators can be created to call these functions (or existing built-in functions) in order to [...]
Tags: CONCAT operator custom operators Extending PostgreSQL PostgreSQL
Posted in: PostgreeSQL
| May 4, 2010
Alexandru Gyulai
| 7 Comments
Windowing Functions in PostgreSQL 8.4
PostgreSQL recently added several great new features like Common Table Expressions (CTE), Recursive CTEs, Windowing Functions (my favorite) and Parallel restoring of dumps. The goal of this article is to provide an overview of the new PostgreSQL Windowing Functions. Previously limited to enterprise databases such as Oracle and DB2, they open up a completely new [...]
Tags: PostgreSQL SQL Windowing Functions
Posted in: PostgreeSQL
| January 11, 2010
Alexandru Gyulai
| 5 Comments
