{"hits":[{"excerpt":"pgTAP 0.93.0 ============ [pgTAP](http://pgtap.org) is a unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL. It includes a comprehensive collection of…","date":"2013-01-28T20:15:00Z","version":"0.93.0","user":"theory","abstract":"Unit testing for PostgreSQL","dist":"pgTAP","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"semver 0.3.0 ============ This library contains a single PostgreSQL extension, a data type called "semver". It's an implementation of the version number format specified by the [Semantic Versioning…","date":"2012-11-20T19:04:19Z","version":"0.3.0","user":"theory","abstract":"A semantic version data type","dist":"semver","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"pair 0.1.5 ========== This library contains a single PostgreSQL extension, a key/value pair data type called `pair`, along with a convenience function for constructing key/value pairs.","date":"2011-11-11T17:56:30Z","version":"0.1.5","user":"theory","abstract":"A key/value pair data type","dist":"pair","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"colnames 1.1.0 ============== This extension contains a single SQL function, `colnames()`, that takes a record value as its argument and returns an array of the names of the columns in that record.","date":"2013-03-01T19:28:44Z","version":"1.2.0","user":"theory","abstract":"Lists the column names in a PostgreSQL RECORD value","dist":"colnames","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"explanation 0.3.0 ================= This extension adds a new function, `explanation()`, to your database. Pass it a string that executes a query and the function runs `EXPLAIN` on the query and…","date":"2011-04-30T00:12:47Z","version":"0.3.0","user":"theory","abstract":"Explain a query and display the nodes as a relation organized as a proximity tree","dist":"explanation","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"citext 2.0.2 ============ This distribution creates a custom PostgreSQL data type, CITEXT, a locale- aware, case-insensitve TEXT type for PostgreSQL 8.3.","date":"2011-07-16T20:17:35Z","version":"2.0.2","user":"theory","abstract":"A case-insensitive text type for PostgreSQL","dist":"citext","score":"3.363","user_name":"David E. Wheeler"},{"excerpt":"hostname 1.0.0 ============== This library contains a single PostgreSQL extension, `hostname`, which provides a function, `hostname()`, that returns the database server's host name:  % SELECT…","date":"2013-04-24T00:22:09Z","version":"1.0.0","user":"theory","abstract":"Get the server host name","dist":"hostname","score":"3.363","user_name":"David E. Wheeler"}],"count":7,"query":"user:theory","limit":50,"offset":0}