Google BigQuery v2 API - Struct BigQueryNumeric (3.2.0)

Version 3.2.0

• 3.10.0 (latest)
• 3.9.0
• 3.8.0
• 3.7.0
• 3.6.0
• 3.5.0
• 3.4.0
• 3.3.0
• 3.2.0
• 3.1.0
• 3.0.0
• 2.4.0
• 2.3.0
• 2.2.0

public struct BigQueryNumeric : IEquatable<BigQueryNumeric>, IComparable<BigQueryNumeric>, IComparable

Reference documentation and code samples for the Google BigQuery v2 API struct BigQueryNumeric.

Representation of the BigQuery NUMERIC type, which has 38 digits of precision, and a fixed scale of 9 decimal places to the right of the decimal point

Implements

IEquatable<BigQueryNumeric>, IComparable<BigQueryNumeric>, IComparable

Inherited Members

Object.GetType()

Namespace

Google.Cloud.BigQuery.V2

Assembly

Google.Cloud.BigQuery.V2.dll

Properties

Epsilon

public static readonly BigQueryNumeric Epsilon { get; }

The smallest positive value for BigQueryNumeric, equal to 0.000000001.

Property Value
Type	Description
BigQueryNumeric

MaxValue

public static readonly BigQueryNumeric MaxValue { get; }

The maximum valid value for BigQueryNumeric, equal to 99999999999999999999999999999.999999999.

Property Value
Type	Description
BigQueryNumeric

MinValue

public static readonly BigQueryNumeric MinValue { get; }

The minimum valid value for BigQueryNumeric, equal to -99999999999999999999999999999.999999999.

Property Value
Type	Description
BigQueryNumeric

Zero

public static readonly BigQueryNumeric Zero { get; }

Zero represented as a BigQueryNumeric. This is the default value for the type.

Property Value
Type	Description
BigQueryNumeric

Methods

CompareTo(BigQueryNumeric)

public int CompareTo(BigQueryNumeric other)

Compares this value with other.

Parameter
Name	Description
other	BigQueryNumeric The value to compare with this one

Returns
Type	Description
Int32	A negative integer if this value is less than other; a positive integer if it's greater than other; zero if they're equal.

FromDecimal(Decimal, LossOfPrecisionHandling)

public static BigQueryNumeric FromDecimal(decimal value, LossOfPrecisionHandling lossOfPrecisionHandling)

Converts a Decimal value to BigQueryNumeric,

Parameters
Name	Description
value	Decimal The value to convert
lossOfPrecisionHandling	LossOfPrecisionHandling How to handle values with signficant digits that would be lost by the conversion.

Returns
Type	Description
BigQueryNumeric	The converted value.

Remarks

This conversion may silently lose precision, depending on lossOfPrecisionHandling.

GetHashCode()

public override int GetHashCode()

Returns a hash code for this value.

Returns
Type	Description
Int32	A hash code for this value.

Overrides

ValueType.GetHashCode()

Parse(String)

public static BigQueryNumeric Parse(string text)

Parses a textual representation as a BigQueryNumeric.

Parameter
Name	Description
text	String The text to parse. Must not be null.

Returns
Type	Description
BigQueryNumeric	The parsed value.

Remarks

text must be a representation of a decimal value which can be represented by BigQueryNumeric, using "." as a decimal place where one is specified, and a leading "-" for negative values. Leading zeroes and insignificant trailing digits are permitted.

Exceptions
Type	Description
FormatException	The value could not be parsed as a BigQueryNumeric.

ToDecimal(LossOfPrecisionHandling)

public decimal ToDecimal(LossOfPrecisionHandling lossOfPrecisionHandling)

Converts this value to BigQueryNumeric,

Parameter
Name	Description
lossOfPrecisionHandling	LossOfPrecisionHandling How to handle values with signficant digits that would be lost by the conversion.

Returns
Type	Description
Decimal	The converted value.

Remarks

This conversion may silently lose precision, depending on lossOfPrecisionHandling, but will always throw OverflowException if value is out of the range of Decimal.

Exceptions
Type	Description
OverflowException	This value is outside the range of Decimal.

ToString()

public override string ToString()

Returns a canonical string representation of this value. This always uses "." as a decimal point, and only includes as many decimal places as are required to completely represent the value. If the value is between -1 and 1 exclusive, a "0" character is included before the decimal point.

Returns
Type	Description
String	A canonical string representation of this value.

Overrides

ValueType.ToString()

TryParse(String, out BigQueryNumeric)

public static bool TryParse(string text, out BigQueryNumeric value)

Attempts to parse a textual representation of a BigQueryNumeric value.

Parameters
Name	Description
text	String The text to parse. Must not be null.
value	BigQueryNumeric The parsed value, or 0 on failure.

Returns
Type	Description
Boolean	true if text was parsed successfully; false otherwise.

Remarks

See Parse(String) for format details. This method will return true if and only if Parse(String) would return without an exception.

Operators

Addition(BigQueryNumeric, BigQueryNumeric)

public static BigQueryNumeric operator +(BigQueryNumeric lhs, BigQueryNumeric rhs)

Returns the result of adding two BigQueryNumeric values together.

Parameters
Name	Description
lhs	BigQueryNumeric The first value to add.
rhs	BigQueryNumeric The second value to add.

Returns
Type	Description
BigQueryNumeric	The result of adding the two values.

Equality(BigQueryNumeric, BigQueryNumeric)

public static bool operator ==(BigQueryNumeric lhs, BigQueryNumeric rhs)

Compares two values for equality.

Parameters
Name	Description
lhs	BigQueryNumeric The first value to compare.
rhs	BigQueryNumeric The second value to compare.

Returns
Type	Description
Boolean	true if the two arguments are equal; false otherwise.

Explicit(BigQueryNumeric to Decimal)

public static explicit operator decimal (BigQueryNumeric value)

Explicit conversion from BigQueryNumeric to Decimal.

Parameter
Name	Description
value	BigQueryNumeric The numeric value to convert.

Returns
Type	Description
Decimal	The result of the conversion.

Remarks

This conversion may silently lose precision, but will throw OverflowException if the value is out of range of Decimal. Use ToDecimal(LossOfPrecisionHandling) passing in Throw for the second argument to avoid any information loss.

Explicit(Decimal to BigQueryNumeric)

public static explicit operator BigQueryNumeric(decimal value)

Explicit conversion from Decimal to BigQueryNumeric.

Parameter
Name	Description
value	Decimal The decimal value to convert.

Returns
Type	Description
BigQueryNumeric	The result of the conversion.

Remarks

This conversion may silently lose precision. Use FromDecimal(Decimal, LossOfPrecisionHandling) passing in Throw for the second argument to avoid any information loss.

Implicit(Int32 to BigQueryNumeric)

public static implicit operator BigQueryNumeric(int value)

Implicit conversion from Int32 to BigQueryNumeric.

Parameter
Name	Description
value	Int32 The integer value to convert.

Returns
Type	Description
BigQueryNumeric	The result of the conversion.

Remarks

This conversion exists to avoid ambiguity between the 64-bit conversions when using an integer literal.

Implicit(Int64 to BigQueryNumeric)

public static implicit operator BigQueryNumeric(long value)

Implicit conversion from Int64 to BigQueryNumeric.

Parameter
Name	Description
value	Int64 The integer value to convert.

Returns
Type	Description
BigQueryNumeric	The result of the conversion.

Implicit(UInt64 to BigQueryNumeric)

public static implicit operator BigQueryNumeric(ulong value)

Implicit conversion from UInt64 to BigQueryNumeric.

Parameter
Name	Description
value	UInt64 The integer value to convert.

Returns
Type	Description
BigQueryNumeric	The result of the conversion.

Inequality(BigQueryNumeric, BigQueryNumeric)

public static bool operator !=(BigQueryNumeric lhs, BigQueryNumeric rhs)

Compares two values for inequality.

Parameters
Name	Description
lhs	BigQueryNumeric The first value to compare.
rhs	BigQueryNumeric The second value to compare.

Returns
Type	Description
Boolean	false if the two arguments are equal; true otherwise.

Subtraction(BigQueryNumeric, BigQueryNumeric)

public static BigQueryNumeric operator -(BigQueryNumeric lhs, BigQueryNumeric rhs)

Returns the result of subtracting one BigQueryNumeric value from another.

Parameters
Name	Description
lhs	BigQueryNumeric The value to subtract from.
rhs	BigQueryNumeric The value to subtract.

Returns
Type	Description
BigQueryNumeric	The result of subtracting rhs from lhs.

UnaryNegation(BigQueryNumeric)

public static BigQueryNumeric operator -(BigQueryNumeric value)

The unary negation operator.

Parameter
Name	Description
value	BigQueryNumeric The value to negate.

Returns
Type	Description
BigQueryNumeric	The negation of value.

UnaryPlus(BigQueryNumeric)

public static BigQueryNumeric operator +(BigQueryNumeric value)

The unary plus operator, provided mainly for consistency.

Parameter
Name	Description
value	BigQueryNumeric The value to return.

Returns
Type	Description
BigQueryNumeric	The original value.

Explicit Interface Implementations

IComparable.CompareTo(Object)

int IComparable.CompareTo(object obj)

Implementation of CompareTo(Object) to compare two BigQueryNumeric values.

Parameter
Name	Description
obj	Object The object to compare this value with.

Returns
Type	Description
Int32	The result of comparing this value with obj. obj is null, this method returns a value greater than 0.

Remarks

This uses explicit interface implementation to avoid it being called accidentally. The generic implementation should usually be preferred.

Exceptions
Type	Description
ArgumentException	obj is non-null but does not refer to an instance of BigQueryNumeric.