From: | "philip taylor" <philtay51(at)mail(dot)com> |
---|---|
To: | "Jim Nasby" <Jim(dot)Nasby(at)BlueTreble(dot)com> |
Cc: | "Kevin Grittner" <kgrittn(at)ymail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Amazon Redshift |
Date: | 2014-11-05 22:36:03 |
Message-ID: | trinity-881d40f5-012b-4f56-a26a-9b5cec5e91c1-1415226962582@3capp-mailcom-lxa12 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-11-05 22:38:45 | Re: WAL format and API changes (9.5) |
Previous Message | Steve Singer | 2014-11-05 22:17:05 | Re: tracking commit timestamps |