Re: Amazon Redshift

>>> 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