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"
→ representation.numeric.integer_number

DuckDB

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

JSON Schema

finetype schema representation.numeric.integer_number
{
  "$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-broad-type": "BIGINT",
  "x-finetype-transform": "CAST({col} AS BIGINT)"
}

Examples

42-170999999999

Aliases

integerwhole_number

Type Registry