Sample Header Ad - 728x90

Unexpected Redshift support for the ISNULL() function. Is this documented?

2 votes
1 answer
4876 views
**As far as I know, the ISNULL() function is only compatible with T-SQL.** Yet, I am working on a Redshift cluster, using Datagrip, that accepts the ISNULL() function and returns results without error. I'm even getting the contextual helptext on it in the IDE. I have found zero Redshift documentation and zero PostgreSQL documentation that even refers to the ISNULL() function, let alone confirms support of it. **Is there documentation out there for support of ISNULL()? Is this function unofficially supported, since it works, but I can't find any documentation?** Redshift environment info: DBMS: Redshift (ver. 8.0.2) Driver: Redshift JDBC Driver (ver. 2.0.0.3, JDBC4.2) Effective version: Amazon Redshift (ver. 1.0.35480)
Asked by dev_etter (762 rep)
Feb 11, 2022, 05:48 PM
Last activity: Mar 2, 2025, 08:32 AM