# boolean type
Expresses TRUE or FALSE

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`boolean` data expresses a binary value of either `TRUE` or `FALSE`.

Detail | Info
-------|------
**Quick Syntax** | `TRUE` or `FALSE`
**Size** | 1 byte
**Aliases** | `bool`
**Catalog name** | `pg_catalog.bool`
**OID** | 16

## Syntax



```mzsql
TRUE | FALSE

```

| Syntax element | Description |
| --- | --- |
| **TRUE** | The boolean value `true`.  |
| **FALSE** | The boolean value `false`.  |


## Details

### Valid casts

#### From `boolean`

You can [cast](https://preview.materialize.com/materialize/40269/markdown-docs/sql/functions/cast/index.md) from `boolean` to:

- [`int`](https://preview.materialize.com/materialize/40269/sql/types/int) (explicitly)
- [`text`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/text/index.md) (by assignment)

#### To `boolean`

You can [cast](https://preview.materialize.com/materialize/40269/markdown-docs/sql/functions/cast/index.md) the following types to `boolean`:

- [`int`](https://preview.materialize.com/materialize/40269/sql/types/int) (explicitly)
- [`jsonb`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/jsonb/index.md) (explicitly)
- [`text`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/text/index.md) (explicitly)

## Examples

```mzsql
SELECT TRUE AS t_val;
```
```nofmt
 t_val
-------
 t
```

```mzsql
SELECT FALSE AS f_val;
 f_val
-------
 f
```