I took a look at the functions in SqlLibraryOperators. Number of Functions (in either PostgreSQL and/or Redshift): 44 Only in PostgreSQL: 5 Only in Redshift: 5 In both with different implementations: 2
This page describes the PostgreSQL functions that are unsupported in Redshift. https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html Unsupported PostgreSQL functions - Amazon Redshift<https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html> Lists the PostgreSQL functions that are not supported in Amazon Redshift. docs.aws.amazon.com In the documentations, Redshift says it is based on PostgreSQL but has a number of important differences. ________________________________ From: Cancai Cai <caic68...@gmail.com> Sent: Monday, June 24, 2024 8:25 AM To: dev@calcite.apache.org <dev@calcite.apache.org> Subject: Re: Function library for Amazon Redshift Does the redshift official website fully explain compatibility with the postgres dialect? If so, I think this is acceptable. Because we must consider that some negative tests of redshift functions are consistent with postgres, otherwise it may cause some trouble to users. > 2024年6月22日 07:13，Julian Hyde <jh...@apache.org> 写道： > > Redshift Warning: The sender of this message could not be validated and may not be the actual sender.
