Reference documentation and code samples for the Cloud Spanner Client class PgNumeric.
Represents a value with a data type of
PG Numeric for the
Postgres Dialect database.
It supports a value precision of up to 131072 digits before the decimal point
and up to 16383 digits after the decimal point.
Example:
use Google\Cloud\Spanner\SpannerClient;
$spanner = new SpannerClient();
$pgNumeric = $spanner->pgNumeric('99999999999999999999999999999999999999.000000999999999');
Namespace
Google \ Cloud \ Spanner
Methods
__construct
Parameter
Name
Description
value
string|int|float|null
The PG_NUMERIC value.
get
Get the underlying value.
Returns
Type
Description
string|null
type
Get the type.
Returns
Type
Description
int
typeAnnotation
Get the type annotation code.
This is to be used along type, to differentiate the value from TypeCode::NUMERIC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Cloud Spanner Client - Class PgNumeric (1.104.0)\n\nVersion latestkeyboard_arrow_down\n\n- [1.104.0 (latest)](/php/docs/reference/cloud-spanner/latest/PgNumeric)\n- [1.103.0](/php/docs/reference/cloud-spanner/1.103.0/PgNumeric)\n- [1.102.0](/php/docs/reference/cloud-spanner/1.102.0/PgNumeric)\n- [1.101.0](/php/docs/reference/cloud-spanner/1.101.0/PgNumeric)\n- [1.100.0](/php/docs/reference/cloud-spanner/1.100.0/PgNumeric)\n- [1.98.0](/php/docs/reference/cloud-spanner/1.98.0/PgNumeric)\n- [1.97.0](/php/docs/reference/cloud-spanner/1.97.0/PgNumeric)\n- [1.96.0](/php/docs/reference/cloud-spanner/1.96.0/PgNumeric)\n- [1.95.0](/php/docs/reference/cloud-spanner/1.95.0/PgNumeric)\n- [1.94.0](/php/docs/reference/cloud-spanner/1.94.0/PgNumeric)\n- [1.93.1](/php/docs/reference/cloud-spanner/1.93.1/PgNumeric)\n- [1.92.1](/php/docs/reference/cloud-spanner/1.92.1/PgNumeric)\n- [1.91.0](/php/docs/reference/cloud-spanner/1.91.0/PgNumeric)\n- [1.90.0](/php/docs/reference/cloud-spanner/1.90.0/PgNumeric)\n- [1.89.0](/php/docs/reference/cloud-spanner/1.89.0/PgNumeric)\n- [1.88.0](/php/docs/reference/cloud-spanner/1.88.0/PgNumeric)\n- [1.87.0](/php/docs/reference/cloud-spanner/1.87.0/PgNumeric)\n- [1.86.0](/php/docs/reference/cloud-spanner/1.86.0/PgNumeric)\n- [1.85.0](/php/docs/reference/cloud-spanner/1.85.0/PgNumeric)\n- [1.84.0](/php/docs/reference/cloud-spanner/1.84.0/PgNumeric)\n- [1.83.0](/php/docs/reference/cloud-spanner/1.83.0/PgNumeric)\n- [1.82.0](/php/docs/reference/cloud-spanner/1.82.0/PgNumeric)\n- [1.81.0](/php/docs/reference/cloud-spanner/1.81.0/PgNumeric)\n- [1.80.0](/php/docs/reference/cloud-spanner/1.80.0/PgNumeric)\n- [1.79.0](/php/docs/reference/cloud-spanner/1.79.0/PgNumeric)\n- [1.78.0](/php/docs/reference/cloud-spanner/1.78.0/PgNumeric)\n- [1.77.0](/php/docs/reference/cloud-spanner/1.77.0/PgNumeric)\n- [1.76.1](/php/docs/reference/cloud-spanner/1.76.1/PgNumeric)\n- [1.68.0](/php/docs/reference/cloud-spanner/1.68.0/PgNumeric)\n- [1.67.0](/php/docs/reference/cloud-spanner/1.67.0/PgNumeric)\n- [1.66.0](/php/docs/reference/cloud-spanner/1.66.0/PgNumeric)\n- [1.65.0](/php/docs/reference/cloud-spanner/1.65.0/PgNumeric)\n- [1.64.0](/php/docs/reference/cloud-spanner/1.64.0/PgNumeric)\n- [1.63.2](/php/docs/reference/cloud-spanner/1.63.2/PgNumeric)\n- [1.62.1](/php/docs/reference/cloud-spanner/1.62.1/PgNumeric)\n- [1.61.0](/php/docs/reference/cloud-spanner/1.61.0/PgNumeric)\n- [1.60.0](/php/docs/reference/cloud-spanner/1.60.0/PgNumeric)\n- [1.59.0](/php/docs/reference/cloud-spanner/1.59.0/PgNumeric)\n- [1.58.4](/php/docs/reference/cloud-spanner/1.58.4/PgNumeric)\n- [1.57.0](/php/docs/reference/cloud-spanner/1.57.0/PgNumeric)\n- [1.56.0](/php/docs/reference/cloud-spanner/1.56.0/PgNumeric)\n- [1.55.0](/php/docs/reference/cloud-spanner/1.55.0/PgNumeric)\n- [1.54.2](/php/docs/reference/cloud-spanner/1.54.2/PgNumeric) \nReference documentation and code samples for the Cloud Spanner Client class PgNumeric.\n\nRepresents a value with a data type of\n[PG Numeric](https://cloud.google.com/spanner/docs/reference/postgresql/data-types) for the\nPostgres Dialect database.\n\nIt supports a value precision of up to 131072 digits before the decimal point\nand up to 16383 digits after the decimal point.\n\nExample: \n\n use Google\\Cloud\\Spanner\\SpannerClient;\n\n $spanner = new SpannerClient();\n\n $pgNumeric = $spanner-\u003epgNumeric('99999999999999999999999999999999999999.000000999999999');\n\nNamespace\n---------\n\nGoogle \\\\ Cloud \\\\ Spanner\n\nMethods\n-------\n\n### __construct\n\n### get\n\nGet the underlying value.\n\n### type\n\nGet the type.\n\n### typeAnnotation\n\nGet the type annotation code.\n\nThis is to be used along type, to differentiate the value from TypeCode::NUMERIC.\n\n### formatAsString\n\nFormat the value as a string.\n\n### __toString\n\nFormat the value as a string."]]