> ## 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_INFINITE function

# IS_INFINITE

Returns `TRUE` if the argument is infinite, and `FALSE` otherwise. Only `REAL` and `DOUBLE PRECISION` types can represent infinity in Firebolt, meaning that `IS_INFINITE` will always return `FALSE` 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 an infinite number. | `NUMERIC`, `DOUBLE PRECISION`, `REAL` |

## Return Type

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

## Examples

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

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

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

  <p><span>Rows: 1</span><span>Execution time: 5.49ms</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_INFINITE(10::REAL);
  ```

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

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