Archive for the ‘PostgreeSQL’ Category

Liferay 6.2 – Installation Guide

Share

Hello! In this tutorial I will tell you how to install and configure Liferay 6.2 with Eclipse.

Share
Tags:        

Porting applications from Oracle to PostgreSQL

Share

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 […]

Share
Tags:  

Extending PostgreSQL – A better CONCAT operator

Share

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 […]

Share
Tags:    

Windowing Functions in PostgreSQL 8.4

Share

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 […]

Share
Tags:   

By continuing to use the site, you agree to the use of cookies. More information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close