In SQL Server, this type of index is called a ”filtered index”. Partial indexes have been supported in PostgreSQL since version 7.2, released in February 2002. MySQL as of version 5.4 does not support partial indexes. Adapted from the Wikipedia article Partial index, under the G. N. U. Free Documentation License. Please also see http://en.wikipedia.org/wiki
Postgresql
The latest articles related to Postgresql
CMS Made Simple is an open source package, built using PHP with support for MySQL and PostgreSQL. The template system is driven using the Smarty Template Engine. CMS Made Simple aims to provide easy development and customization with themes, add-on modules, dynamic menus, tags and translations. Adapted from the Wikipedia article CMS Made Simple, under [...]
It is hard to determine with certainty whether these sites run on the open source or the closed source version of GForge. The guesses were made on 2010-02-15 based on the look-and-feel of these sites. *LuaForge – for the Lua community (free GForge 4.x). *RubyForge – for the Ruby community (free GForge 4.x). *[http://gforge.uwc.ac.za AVOIR [...]
Since its beginnings OTRS has been implemented in the programming language Perl. The web interface is made more user-friendly by using JavaScript (which can be switched off for security reasons). Different functionalities are implemented as reusable backend modules, making it possible to create custom modules to extend the functionality of the OTRS system. The web [...]
InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support, similar to PostgreSQL, along with foreign key support (Declarative Referential Integrity). InnoDB became a product of Oracle Corporation after their acquisition [...]
SPINE is a free, open source content management system for publishing content on the World Wide Web and intranets. The system includes features like easy Web-based administration, full template support to separate style from content, common components like navigation bars, macros, message boards, and page statistics, and the ability to mix static and dynamic content [...]
The business logic of Evergreen is written primarily in Perl and PostgreSQL, with a few optimized sections rewritten in C. The catalog interface is primarily JavaScript with XHTML, and the staff client user interface is written in Mozilla’s XUL (XML + JavaScript). The user interface for most new staff client functionality is being built with [...]
Likewise, any one user interface can be kept intentionally oblivious of a wide variety of different models that may underly the mediating controller or adapter. For example, the same website can be kept oblivious of the fact that it can be served by an SQL database server such as PostgreSQL, Sybase, or SQL Server that [...]
Related Videos
Enterprise relational database solutions typically come with a hefty price tag, but PostgreSQL has proven to be an enterprise-capable open source alternative. EnterpriseDB is like...
A screencast on how to install PostgreSQL (aka postgres) using homebrew on Mac OS X (Snow Leopard) and set it up for doing work with...
Uso de Vistas y Triggers en PostgreSQL...
