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
(Jaime Casanova <jaime@2ndquadrant.com>)
Re: Amazon Redshift (Andrea Suisani <sickpig@opinioni.net>) Re: Amazon Redshift (Bernd Helmle <mailings@oopsware.de>) |
| 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: