Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# SQL functions reference
<a name="c_SQL_functions"></a>

**Topics**
+ [Leader node–only functions](c_SQL_functions_leader_node_only.md)
+ [Aggregate functions](c_Aggregate_Functions.md)
+ [Array functions](c_Array_Functions.md)
+ [Bit-wise aggregate functions](c_bitwise_aggregate_functions.md)
+ [Conditional expressions](c_conditional_expressions.md)
+ [Data type formatting functions](r_Data_type_formatting.md)
+ [Date and time functions](Date_functions_header.md)
+ [Hash functions](hash-functions.md)
+ [HyperLogLog functions](hyperloglog-functions.md)
+ [JSON functions](json-functions.md)
+ [Machine learning functions](ml-function.md)
+ [Math functions](Math_functions.md)
+ [Object functions](Object_Functions.md)
+ [Spatial functions](geospatial-functions.md)
+ [String functions](String_functions_header.md)
+ [SUPER type information functions](c_Type_Info_Functions.md)
+ [VARBYTE functions and operators](varbyte-functions.md)
+ [Window functions](c_Window_functions.md)
+ [System administration functions](r_System_administration_functions.md)
+ [System information functions](r_System_information_functions.md)

Amazon Redshift supports a number of functions that are extensions to the SQL standard, as well as standard aggregate functions, scalar functions, and window functions.

**Note**  
Amazon Redshift is based on PostgreSQL. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. For more information about how Amazon Redshift SQL differs from PostgreSQL, see [Amazon Redshift and PostgreSQL](c_redshift-and-postgres-sql.md).