Values
NAME
Value, DataType: the values the low-level client gives and takes,
and the types of columns and parameters.
SYNOPSIS
type Value interface{ /* sealed */ }
type DataType interface{ /* sealed */ }
func NewDecimal(units *big.Int, scale uint32) (Decimal, error)
func DecimalOf(units int64, scale uint32) Decimal
func NewDecFloat(coefficient *big.Int, exponent int32) (DecFloat, error)
func NewInterval(qualifier Qualifier, units *big.Int) (Interval, error)
func NewJSON(item JSONItem) (JSON, error)
func JSONOf(doc []byte) (JSON, error)
func ParseUUID(text string) (UUID, error)
DESCRIPTION
A value of a row, or of a parameter, is one of the package's value types, and a column's or a parameter's type one of its type types; Appendix A lists each against its protocol tag, with its fields and bounds. Both interfaces are sealed: only the package's own types implement them, so a type switch over them names every case.
An exact number is a Decimal, which holds every units and scale the
protocol carries and gives its units as a *big.Int; its String writes
it as SQL does, as -12.50. A DECFLOAT is a DecFloat, kept in
Turborel's one form; NewDecFloat rounds a coefficient of more than 34
digits half to even, as Turborel does, and a JSON value's DECFLOAT is
read the same way; its String writes it as Turborel does, plain, as
1.5, if its leading digit's exponent is from -6 to 33, else as
1.5E-7. A datetime is a Datetime, its instant in UTC
microseconds from 0001-01-01 with its displacement, whose Time gives
a time.Time. A JSON value is a JSON, its stored form checked whole,
whose Item gives its SQL/JSON item. A UUID is a UUID, whose String
gives its text.
The values a program gets come from the server's replies, and the
values it sends are written as the protocol says, the reply checked as
Turborel's own client checks it. A CLOB or BLOB comes whole, a LOB, or
by its locator, a Locator (Large Objects).
An interval's Qualifier has a String that writes it as SQL does, as
DAY(2) TO SECOND(6).
ERRORS
| SQLSTATE | When |
|---|---|
| 22003 | NewDecimal or NewInterval of units outside a signed 128-bit integer; NewDecFloat out of DECFLOAT's range; ParseUUID of text that is no UUID |
| 22032 | JSONOf of octets that are not a stored JSON value |
| 0A000 | SQLCODE -900: NewJSON of an item nested deeper than 128, or stored in more than 256 MiB |
| 08006 | A reply holding a value that is malformed, SQLCODE -919: the connection fails |
EXAMPLES
The examples of Running Queries.
STANDARD
[PROTOCOL Data types], [PROTOCOL Values] and [PROTOCOL JSON values] of The Native Protocol; [CLIENT XML values] and [CLIENT UUIDs] of The Client Library.