MeridianMERIDIAN

Integer Number

Whole number without fractional part. String representation of an integer. Transforms to BIGINT or INTEGER depending on value range.

Integer Number

representation.numeric.integer_number

Whole number without fractional part. String representation of an integer. Transforms to BIGINT or INTEGER depending on value range.

Domain
representation
Category
numeric
Casts to
BIGINT
Scope
Universal

Try it

CLI
$ finetype infer -i "42" --mode column
→ representation.numeric.integer_number

DuckDB

Detect
SELECT ft_infer('42');
-- → 'representation.numeric.integer_number'
Cast expression
CAST({col} AS BIGINT)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS BIGINT) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'representation.numeric.integer_number';

JSON Schema

finetype taxonomy representation.numeric.integer_number -o json-schema
{
  "$id": "https://meridian.online/schemas/representation.numeric.integer_number",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Whole number without fractional part. String representation of an integer. Transforms to BIGINT or INTEGER depending on value range.",
  "examples": [
    "42",
    "-17",
    "0",
    "999999999"
  ],
  "pattern": "^-?[0-9]+$",
  "title": "Integer Number",
  "type": "string",
  "x-finetype-label": "representation.numeric.integer_number",
  "x-finetype-pii": false
}

Examples

42-170999999999

Aliases

integerwhole_number

Type Registry