Skip to content

Translation and complements for SQL and PL/pgSQL #2

@ppKrauss

Description

@ppKrauss

PostgreSQL offers native bit string datatype, the bit varying, and int8 (also called "bigint", not be confused with arbitrary-pecision Javascript's BigInt), that are the main tools and casts for SizedNaturals when using with indexes (geocodes, hashes, etc.) with maximum of 62 bits — there is a loss by signal and "hidden bit strategy".

For PostgreSQL the arbitrary-precision number is the datatype numeric, that is the real analog of Javascript's BigInt, and can be used for implementations focusing on generic SizedNaturals.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions