Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, 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/) that was published on June 30, 2025. 

# extra\_float\_digits
<a name="r_extra_float_digits"></a>

## Values (default in bold)
<a name="r_extra_float_digits-values"></a>

 **0**, -15 to 2 

## Description
<a name="r_extra_float_digits-description"></a>

Sets the number of digits displayed for floating-point values, including float4 and float8. The value is added to the standard number of digits (FLT\_DIG or DBL\_DIG as appropriate). The value can be set as high as 2, to include partially significant digits. This is especially useful for outputting float data that must be restored exactly. Or it can be set negative to suppress unwanted digits. 

## Example
<a name="r_extra_float_digits-example"></a>

The following example sets `extra_float_digits` to `-2`. First, show the current parameter setting.

```
show all;
      name                      | setting      
--------------------------+----------------
analyze_threshold_percent | 10           
datestyle                 | ISO, MDY     
extra_float_digits        | 2            
query_group               | default      
search_path               | $user, public
statement_timeout         | 0            
timezone                  | UTC            
wlm_query_slot_count      | 1
```

Then, set the new value to `-2`.

```
set extra_float_digits to -2;
```

Finally show the updated parameter setting.

```
show all;
      name                      | setting      
--------------------------+----------------
analyze_threshold_percent | 10           
datestyle                 | ISO, MDY     
extra_float_digits        | -2            
query_group               | default      
search_path               | $user, public
statement_timeout         | 0            
timezone                  | UTC            
wlm_query_slot_count      | 1
```