Redshift PostgresQL syntax: is named window clause valid?

Question

I suspect that Redshift does not support named windows, as Postgres has since at least version 8.4:

select stuff
       , stuff_category
       , sum(dollars) over W

from   table

window W as (partition by stuff_category)

However I would like to know definitively and I can't find a reference, or any post that says 'no we didn't implement this for very good reason yada yada.'

The AWS Redshift SQL Reference makes no mention of the 'window as' syntax - I suppose I should take this as an answer.

Here's an SO answer relating to Postgres named windows

Here's the Postgres 8.4 documentation on WINDOW AS () syntax

Don't read the Postgres documentation. Read the Redshift manual — user330315
– user330315, Commented Jan 19, 2018 at 18:19

Merlin · Accepted Answer · 2018-01-19 17:59:40Z

9

Redshift does not support named windows.

As I have learned over time, the RS documentation will specify what is supported and if not mentioned its safe to assume it is not supported. There are no easter eggs or undocumented features to try and find, Legend of Zelda style.

AWS Window Function Documentation

AWS Docs Redshift and Postgres Comparison This does not mention window functions, but is a good resource for this type of question.

answered Jan 19, 2018 at 17:59

Merlin

2,0171 gold badge21 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Redshift PostgresQL syntax: is named window clause valid?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related