Download Browse

hashtypes-aleksabl

This Release
hashtypes-aleksabl 0.1.4
Date
Status
Stable
Other Releases
Abstract
Data types for sha{1,224,256,384,512}, md5 and crc32.
Description
Data types for hashtypes for optimal storage and performance. Support for indexes (normal btree as well as hash), comparision, min/max, binary export/import, etc. This project is a fork of https://pgxn.org/dist/hashtypes/.
Released By
aleksabl
License
PostgreSQL
Resources
Special Files
Tags

Extensions

hashtypes-aleksabl 0.1.4

README

PGXN version Build Status

About this project

This project is a fork of https://github.com/infofarmer/hashtypes. This fork provides the following enhancements:

  • Support for BINARY export/import
  • Support for aggregate functions (min/max)
  • Fixed versioning with regards to PGXN
  • Support for parallelism (for Postgresql 9.6+)
  • Some performance enhancements

Installation

The easiest way to get started with this project is to use PGXN.

First: Install pgxn (sudo apt install pgxnclient or similar for other distros). Then run sudo pgxnclient install aleksabl-hashtypes.

Use

Connect to the database you want. First you need to install the extension for the current database: CREATE EXTENSION hashtypes.

Example usage: ``` CREATE TABLE shatest(a sha256) INSERT INTO shatest VALUES ('aec750369ad69194f076f675afae3872e8d1a5f3b6c68ec3f9278f'); INSERT INTO shatest VALUES ('000000369ad69194f076f675afae3872e8d1a5f3b6c68ec3f9278f');

select * from shatest where a > '100000000000000000000000000000000000000000000000000000'); ```