19 нояб. 2020 г. · I have also used SYSDATE, GETDATE(), NOW() instead of CURRENT_DATE as well. but everything is mutable function it seems. it is throwing an error ...

12 июл. 2021 г. · It is giving error saying " materialized view cannot be created, reason: auto refresh is not supported for materialized view with mutable function.

3 авг. 2018 г. · However, it seems to have quite slow performance in my specific use case, potentially worse than just using the STABLE SQL UDF. AWS Collective.

17 февр. 2015 г. · The key word IMMUTABLE is never added automatically by pgAdmin or Postgres. Whoever created or replaced the function did that.

17 янв. 2018 г. · I think the stl_query table is indeed immutable, it would seem that it's only written to after a query finishes. Here is why I think that.

13 июн. 2015 г. · No, Amazon Redshift does not have the concept of variables. Redshift presents itself as PostgreSQL, but is highly modified.

17 мая 2021 г. · I am looking to extract value for the key category from each json inside the array. I am unsure how to proceed.

4 янв. 2023 г. · I tried in the past to implement that function, but I never get the same result as EPOCH maybe because of the bisextile years of for some ...

21 сент. 2020 г. · In Redshift, you could write this as: create function ms_epoch_to_ts(int) returns timestamp immutable as $$ select timestamp 'epoch' + $1 ...

2 авг. 2018 г. · I have a complex Redshift view looking to filter results based on a variable date range. So I have to compare a date and interval to CURRENT_DATE.