...
▽

Package zeronull

import "github.com/jackc/pgtype/zeronull"
Overview
Index

Overview ▾

Package zeronull contains types that automatically convert between database NULLs and Go zero values.

Sometimes the distinction between a zero value and a NULL value is not useful at the application level. For example, in PostgreSQL an empty string may be stored as NULL. There is usually no application level distinction between an empty string and a NULL string. Package zeronull implements types that seamlessly convert between PostgreSQL NULL and the zero value.

It is recommended to convert types at usage time rather than instantiate these types directly. In the example below, middlename would be stored as a NULL. 

firstname := "John"
middlename := ""
lastname := "Smith"
_, err := conn.Exec(
	ctx,
	"insert into people(firstname, middlename, lastname) values($1, $2, $3)",
	zeronull.Text(firstname),
	zeronull.Text(middlename),
	zeronull.Text(lastname),
)

Index ▾

type Float8
    func (dst *Float8) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Float8) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Float8) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Float8) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Float8) Scan(src interface{}) error
    func (src Float8) Value() (driver.Value, error)
type Int2
    func (dst *Int2) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Int2) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Int2) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Int2) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Int2) Scan(src interface{}) error
    func (src Int2) Value() (driver.Value, error)
type Int4
    func (dst *Int4) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Int4) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Int4) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Int4) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Int4) Scan(src interface{}) error
    func (src Int4) Value() (driver.Value, error)
type Int8
    func (dst *Int8) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Int8) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Int8) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Int8) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Int8) Scan(src interface{}) error
    func (src Int8) Value() (driver.Value, error)
type Text
    func (dst *Text) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Text) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Text) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Text) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Text) Scan(src interface{}) error
    func (src Text) Value() (driver.Value, error)
type Timestamp
    func (dst *Timestamp) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Timestamp) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Timestamp) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Timestamp) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Timestamp) Scan(src interface{}) error
    func (src Timestamp) Value() (driver.Value, error)
type Timestamptz
    func (dst *Timestamptz) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *Timestamptz) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src Timestamptz) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src Timestamptz) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *Timestamptz) Scan(src interface{}) error
    func (src Timestamptz) Value() (driver.Value, error)
type UUID
    func (dst *UUID) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error
    func (dst *UUID) DecodeText(ci *pgtype.ConnInfo, src []byte) error
    func (src UUID) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (src UUID) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)
    func (dst *UUID) Scan(src interface{}) error
    func (src UUID) Value() (driver.Value, error)

Package files

doc.go float8.go int2.go int4.go int8.go text.go timestamp.go timestamptz.go uuid.go

type Float8 

type Float8 float64

func (*Float8) DecodeBinary 

func (dst *Float8) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Float8) DecodeText 

func (dst *Float8) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Float8) EncodeBinary 

func (src Float8) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Float8) EncodeText 

func (src Float8) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Float8) Scan 

func (dst *Float8) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Float8) Value 

func (src Float8) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Int2 

type Int2 int16

func (*Int2) DecodeBinary 

func (dst *Int2) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Int2) DecodeText 

func (dst *Int2) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Int2) EncodeBinary 

func (src Int2) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Int2) EncodeText 

func (src Int2) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Int2) Scan 

func (dst *Int2) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Int2) Value 

func (src Int2) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Int4 

type Int4 int32

func (*Int4) DecodeBinary 

func (dst *Int4) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Int4) DecodeText 

func (dst *Int4) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Int4) EncodeBinary 

func (src Int4) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Int4) EncodeText 

func (src Int4) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Int4) Scan 

func (dst *Int4) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Int4) Value 

func (src Int4) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Int8 

type Int8 int64

func (*Int8) DecodeBinary 

func (dst *Int8) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Int8) DecodeText 

func (dst *Int8) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Int8) EncodeBinary 

func (src Int8) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Int8) EncodeText 

func (src Int8) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Int8) Scan 

func (dst *Int8) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Int8) Value 

func (src Int8) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Text 

type Text string

func (*Text) DecodeBinary 

func (dst *Text) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Text) DecodeText 

func (dst *Text) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Text) EncodeBinary 

func (src Text) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Text) EncodeText 

func (src Text) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Text) Scan 

func (dst *Text) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Text) Value 

func (src Text) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Timestamp 

type Timestamp time.Time

func (*Timestamp) DecodeBinary 

func (dst *Timestamp) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Timestamp) DecodeText 

func (dst *Timestamp) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Timestamp) EncodeBinary 

func (src Timestamp) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Timestamp) EncodeText 

func (src Timestamp) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Timestamp) Scan 

func (dst *Timestamp) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Timestamp) Value 

func (src Timestamp) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Timestamptz 

type Timestamptz time.Time

func (*Timestamptz) DecodeBinary 

func (dst *Timestamptz) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*Timestamptz) DecodeText 

func (dst *Timestamptz) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (Timestamptz) EncodeBinary 

func (src Timestamptz) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (Timestamptz) EncodeText 

func (src Timestamptz) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*Timestamptz) Scan 

func (dst *Timestamptz) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (Timestamptz) Value 

func (src Timestamptz) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type UUID 

type UUID [16]byte

func (*UUID) DecodeBinary 

func (dst *UUID) DecodeBinary(ci *pgtype.ConnInfo, src []byte) error

func (*UUID) DecodeText 

func (dst *UUID) DecodeText(ci *pgtype.ConnInfo, src []byte) error

func (UUID) EncodeBinary 

func (src UUID) EncodeBinary(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (UUID) EncodeText 

func (src UUID) EncodeText(ci *pgtype.ConnInfo, buf []byte) ([]byte, error)

func (*UUID) Scan 

func (dst *UUID) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (UUID) Value 

func (src UUID) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.