types

Documentation

Index

• func Array(a interface{}) interface{ ... }
• type ArrayDelimiter
• type BoolArray
  • func (a *BoolArray) Scan(src interface{}) error
  • func (a BoolArray) Value() (driver.Value, error)
• type BytesArray
  • func (a *BytesArray) Scan(src interface{}) error
  • func (a BytesArray) Value() (driver.Value, error)
• type Float64Array
  • func (a *Float64Array) Scan(src interface{}) error
  • func (a Float64Array) Value() (driver.Value, error)
• type HStore
  • func (h *HStore) Scan(value interface{}) error
  • func (h HStore) Value() (driver.Value, error)
• type Int64Array
  • func (a *Int64Array) Scan(src interface{}) error
  • func (a Int64Array) Value() (driver.Value, error)
• type JSON
  • func (j *JSON) Marshal(obj interface{}) error
  • func (j JSON) MarshalJSON() ([]byte, error)
  • func (j *JSON) Scan(src interface{}) error
  • func (j JSON) String() string
  • func (j JSON) Unmarshal(dest interface{}) error
  • func (j *JSON) UnmarshalJSON(data []byte) error
  • func (j JSON) Value() (driver.Value, error)
• type StringArray
  • func (a *StringArray) Scan(src interface{}) error
  • func (a StringArray) Value() (driver.Value, error)

Functions

func Array

func Array(a interface{}) interface {
	driver.Valuer
	sql.Scanner
}

Array returns the optimal driver.Valuer and sql.Scanner for an array or slice of any dimension.

For example:

db.Query(`SELECT * FROM t WHERE id = ANY($1)`, pq.Array([]int{235, 401}))

var x []sql.NullInt64
db.QueryRow('SELECT ARRAY[235, 401]').Scan(pq.Array(&x))

Scanning multi-dimensional arrays is not supported. Arrays where the lower bound is not one (such as `[0:0]={1}') are not supported.

Types

type ArrayDelimiter

type ArrayDelimiter interface {
	// ArrayDelimiter returns the delimiter character(s) for this element's type.
	ArrayDelimiter() string
}

ArrayDelimiter may be optionally implemented by driver.Valuer or sql.Scanner to override the array delimiter used by GenericArray.

type BoolArray

type BoolArray []bool

BoolArray represents a one-dimensional array of the PostgreSQL boolean type.

func (*BoolArray) Scan

func (a *BoolArray) Scan(src interface{}) error

Scan implements the sql.Scanner interface.

func (BoolArray) Value

func (a BoolArray) Value() (driver.Value, error)

Value implements the driver.Valuer interface.

type BytesArray

type BytesArray [][]byte

BytesArray represents a one-dimensional array of the PostgreSQL bytea type.

func (*BytesArray) Scan

func (a *BytesArray) Scan(src interface{}) error

Scan implements the sql.Scanner interface.

func (BytesArray) Value

func (a BytesArray) Value() (driver.Value, error)

Value implements the driver.Valuer interface. It uses the "hex" format which is only supported on PostgreSQL 9.0 or newer.

type Float64Array

type Float64Array []float64

Float64Array represents a one-dimensional array of the PostgreSQL double precision type.

func (*Float64Array) Scan

func (a *Float64Array) Scan(src interface{}) error

Scan implements the sql.Scanner interface.

func (Float64Array) Value

func (a Float64Array) Value() (driver.Value, error)

Value implements the driver.Valuer interface.

type HStore

type HStore map[string]sql.NullString

HStore is a wrapper for transferring HStore values back and forth easily.

func (*HStore) Scan

func (h *HStore) Scan(value interface{}) error

Scan implements the Scanner interface.

Note h is reallocated before the scan to clear existing values. If the hstore column's database value is NULL, then h is set to nil instead.

func (HStore) Value

func (h HStore) Value() (driver.Value, error)

Value implements the driver Valuer interface. Note if h is nil, the database column value will be set to NULL.

type Int64Array

type Int64Array []int64

func (*Int64Array) Scan

func (a *Int64Array) Scan(src interface{}) error

Scan implements the sql.Scanner interface.

func (Int64Array) Value

func (a Int64Array) Value() (driver.Value, error)

Value implements the driver.Valuer interface.

type JSON

type JSON json.RawMessage

JSON is an alias for json.RawMessage, which is a []byte underneath. JSON implements Marshal and Unmarshal.

func (*JSON) Marshal

func (j *JSON) Marshal(obj interface{}) error

Marshal obj into your JSON variable.

func (JSON) MarshalJSON

func (j JSON) MarshalJSON() ([]byte, error)

MarshalJSON returns j as the JSON encoding of j.

func (*JSON) Scan

func (j *JSON) Scan(src interface{}) error

Scan stores the src in *j.

func (JSON) String

func (j JSON) String() string

String output your JSON.

func (JSON) Unmarshal

func (j JSON) Unmarshal(dest interface{}) error

Unmarshal your JSON variable into dest.

func (*JSON) UnmarshalJSON

func (j *JSON) UnmarshalJSON(data []byte) error

UnmarshalJSON sets *j to a copy of data.

func (JSON) Value

func (j JSON) Value() (driver.Value, error)

Value returns j as a value. Unmarshal into RawMessage for validation.

type StringArray

type StringArray []string

StringArray represents a one-dimensional array of the PostgreSQL character types.

func (*StringArray) Scan

func (a *StringArray) Scan(src interface{}) error

Scan implements the sql.Scanner interface.

func (StringArray) Value

func (a StringArray) Value() (driver.Value, error)

Value implements the driver.Valuer interface.