Re: [HACKERS] Amazon Redshift

2014-11-05 Thread philip taylor
>>> do you think we should implement some of the functions offered by >>> Amazon Redshift? >>> >>> http://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html >> >> Well, obviously we already have many of the functions linked from >> that page. I think that if you want to go through them and

[HACKERS] Amazon Redshift

2014-11-05 Thread philip taylor
Hackers,   do you think we should implement some of the functions offered by Amazon Redshift?   http://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html   Amazon Redshift is completely based on PostgreSQL, but they have implemented some features not currently available in PostgreSQL.

[HACKERS] array exclusion constraint

2012-11-17 Thread Philip Taylor
CREATE TABLE foo (    x CHAR(32) PRIMARY KEY,    y CHAR(32) NOT NULL,    EXCLUDE USING gist ((ARRAY[x, y]) WITH &&) ); ERROR:  data type character[] has no default operator class for access method "gist" HINT:  You must specify an operator class for the index or define a default operator class f

[HACKERS] Add SHA-3 (Keccak) support to pgcrypto

2012-10-19 Thread Philip Taylor
On Oct 2 the latest crypto hash function was announced by NIST [1]. I suggest that we include the new hash algorithm in pgcrypto for 9.3. The Keccak site also has a reference implementation in C and Assembler [2]. It may take some effort to integrate the reference implementation as it contains s