Skip to main content

Function Case

Controls the casing of function names independently from keyword casing.

Scope: Applies to regular function calls (count(), sum()) and special function keywords (COALESCE, NULLIF, GREATEST, LEAST). Also applies to schema-qualified function names.

Default: Follows keywordCase. Override with functionCase to set independently.

Default follows keyword case​

Default: functionCase follows keywordCase (UPPER for ANSI).

select count(*), sum(a) from t
select count(*), sum(a) from t

Function case LOWER with UPPER keywords​

Function names lowercase, keywords uppercase.

select COUNT(*), SUM(a) from t
select count(*), sum(a) from t

Function case UPPER with LOWER keywords​

Function names uppercase, keywords lowercase.

select count(*), sum(a) from t
select COUNT(*), SUM(a) from t

Function case PRESERVE​

Keep original casing for function names.

select Count(*), SUM(a) from t
select Count(*), SUM(a) from t

Function case applies to COALESCE​

SpecialFunction keywords (COALESCE) also use functionCase.

select coalesce(a, b) from t
select coalesce(a, b) from t

Function case applies to schema-qualified functions​

Schema-qualified function name: my_schema.my_func(a).

select my_schema.my_func(a) from t
select my_schema.my_func (a) from t