> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for the IS_FINITE function

# IS_FINITE

Returns `TRUE` if the argument is finite, and `FALSE` otherwise. Only `REAL` and `DOUBLE PRECISION` types can represent infinity in Firebolt, meaning that `IS_FINITE` will always return `TRUE` for `NUMERIC` inputs.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
IS_FINITE(<value>);
```

## Parameters

| Parameter | Description                                                           | Supported input types                 |
| :-------- | :-------------------------------------------------------------------- | :------------------------------------ |
| `<value>` | The input that will be checked to determine if it is a finite number. | `NUMERIC`, `DOUBLE PRECISION`, `REAL` |

## Return Type

`IS_FINITE` returns a value of type `BOOLEAN`.

## Examples

The following example checks whether the value inf, after being cast to a `DOUBLE PRECISION` data type, is a finite number:

<div className="query-window">
  ```
  SELECT IS_FINITE('inf'::DOUBLE PRECISION);
  ```

  | is\_finite <span>boolean</span> |
  | :------------------------------ |
  | False                           |

  <p><span>Rows: 1</span><span>Execution time: 6.08ms</span></p>
</div>

The following code example checks whether the value 10, after being cast to a `REAL` data type, is an infinite number:

<div className="query-window">
  ```
  SELECT IS_FINITE(10::REAL);
  ```

  | is\_finite <span>boolean</span> |
  | :------------------------------ |
  | True                            |

  <p><span>Rows: 1</span><span>Execution time: 5.42ms</span></p>
</div>