Re: Amazon Redshift - Mailing list pgsql-hackers

From philip taylor
Subject Re: Amazon Redshift
Date
Msg-id trinity-881d40f5-012b-4f56-a26a-9b5cec5e91c1-1415226962582@3capp-mailcom-lxa12
Whole thread Raw
In response to Re: Amazon Redshift  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Amazon Redshift
Re: Amazon Redshift
Re: Amazon Redshift
List pgsql-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
>>
>> Well, obviously we already have many of the functions linked from
>> that page. I think that if you want to go through them and pick
>> out a few that you think are particularly promising it could start
>> a useful discussion. Pointing at a page that includes such things
>> as CURRENT_DATE, the avg() aggregate, and the lead() window
>> function is just going to waste the time of everyone who follows
>> the link. It's not like all of them would be committed in the same
>> patch anyway.
>
> At the risk stating the obvious, before we look at implementing them we should see if Amazon would donate that
effort.
>
> But as Kevin said, first step is discussion on what we don't have and whether we want it.

Ok, this is a summary of what they have that we don't (of course, I could have missed something):

Date Functions

http://docs.aws.amazon.com/redshift/latest/dg/r_ADD_MONTHS.html
http://docs.aws.amazon.com/redshift/latest/dg/r_DATEADD_function.html
http://docs.aws.amazon.com/redshift/latest/dg/r_DATEDIFF_function.html
http://docs.aws.amazon.com/redshift/latest/dg/r_LAST_DAY.html
http://docs.aws.amazon.com/redshift/latest/dg/r_MONTHS_BETWEEN_function.html
http://docs.aws.amazon.com/redshift/latest/dg/r_NEXT_DAY.html

String Functions

http://docs.aws.amazon.com/redshift/latest/dg/REGEXP_COUNT.html
http://docs.aws.amazon.com/redshift/latest/dg/REGEXP_INSTR.html
http://docs.aws.amazon.com/redshift/latest/dg/r_STRTOL.html
http://docs.aws.amazon.com/redshift/latest/dg/crc32-function.html
http://docs.aws.amazon.com/redshift/latest/dg/FUNC_SHA1.html

JSON Functions

http://docs.aws.amazon.com/redshift/latest/dg/JSON_ARRAY_LENGTH.html
http://docs.aws.amazon.com/redshift/latest/dg/JSON_EXTRACT_ARRAY_ELEMENT_TEXT.html
http://docs.aws.amazon.com/redshift/latest/dg/JSON_EXTRACT_PATH_TEXT.html

Window functions

http://docs.aws.amazon.com/redshift/latest/dg/r_WF_RATIO_TO_REPORT.html
http://docs.aws.amazon.com/redshift/latest/dg/r_WF_MEDIAN.html



pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: tracking commit timestamps
Next
From: Andres Freund
Date:
Subject: Re: WAL format and API changes (9.5)