>>> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
