postgres

package

Go to main page

Versions in this module

v2

v2.13.0

Mar 16, 2025

Changes in this version

+ var BIT_COUNT = jet.BIT_COUNT

+ var Base64 = StringExp(jet.FixedLiteral("base64"))

+ var ByteaColumn = jet.BlobColumn

+ var ByteaExp = jet.BlobExp

+ var Escape = StringExp(jet.FixedLiteral("escape"))

+ var Hex = StringExp(jet.FixedLiteral("hex"))

+ var ISO_8859_5 = StringExp(jet.FixedLiteral("ISO_8859_5"))

+ var ISO_8859_6 = StringExp(jet.FixedLiteral("ISO_8859_6"))

+ var ISO_8859_7 = StringExp(jet.FixedLiteral("ISO_8859_7"))

+ var ISO_8859_8 = StringExp(jet.FixedLiteral("ISO_8859_8"))

+ var KOI8R = StringExp(jet.FixedLiteral("KOI8R"))

+ var KOI8U = StringExp(jet.FixedLiteral("KOI8U"))

+ var LATIN1 = StringExp(jet.FixedLiteral("LATIN1"))

+ var LATIN2 = StringExp(jet.FixedLiteral("LATIN2"))

+ var LATIN3 = StringExp(jet.FixedLiteral("LATIN3"))

+ var LATIN4 = StringExp(jet.FixedLiteral("LATIN4"))

+ var RawBytea = jet.RawBlob

+ var UTF8 = StringExp(jet.FixedLiteral("UTF8"))

+ var WIN1252 = StringExp(jet.FixedLiteral("WIN1252"))

+ type ByteaExpression = jet.BlobExpression

+ func SET_BIT(bytes ByteaExpression, n IntegerExpression, newValue IntegerExpression) ByteaExpression

+ func SET_BYTE(bytes ByteaExpression, n IntegerExpression, newValue IntegerExpression) ByteaExpression

+ func SHA224(bytes ByteaExpression) ByteaExpression

+ func SHA256(bytes ByteaExpression) ByteaExpression

+ func SHA384(bytes ByteaExpression) ByteaExpression

+ func SHA512(bytes ByteaExpression) ByteaExpression

+ type ColumnBytea = jet.ColumnBlob

type IntegerExpression

+ func GET_BIT(bytes ByteaExpression, n IntegerExpression) IntegerExpression

+ func GET_BYTE(bytes ByteaExpression, n IntegerExpression) IntegerExpression

type SelectStatement

+ func SELECT_JSON_ARR(projections ...Projection) SelectStatement

+ func SELECT_JSON_OBJ(projections ...Projection) SelectStatement

v2.12.0

Nov 3, 2024

Changes in this version

+ var BinaryOperator = jet.BinaryOperator

+ var CustomExpression = jet.CustomExpression

+ var RowExp = jet.RowExp

+ func Char(length ...int) func(value string) StringExpression

+ func VALUES(rows ...RowExpression) values

+ func VarChar(length ...int) func(value string) StringExpression

type ColumnInterval

+ SET func(intervalExp IntervalExpression) ColumnAssigment

type Expression

+ func GENERATE_SERIES(start Expression, stop Expression, step ...Expression) Expression

type FloatExpression

+ func Double(value float64) FloatExpression

+ func Real(value float32) FloatExpression

+ type RowExpression = jet.RowExpression

type StringExpression

+ func Text(value string) StringExpression

type TimestampExpression

+ func DATE_TRUNC(field unit, source Expression, timezone ...string) TimestampExpression

+ type Token = jet.Token

v2.11.1

Mar 24, 2024

v2.11.0

Feb 27, 2024

Changes in this version

+ var DATE_RANGE = jet.DateRange

+ var DateRangeColumn = jet.RangeColumn[DateExpression]

+ var DateRangeExp = jet.DateRangeExp

+ var INT4_RANGE = jet.Int4Range

+ var INT8_RANGE = jet.Int8Range

+ var Int4RangeColumn = jet.RangeColumn[jet.Int4Expression]

+ var Int4RangeExp = jet.Int4RangeExp

+ var Int8RangeColumn = jet.RangeColumn[jet.Int8Expression]

+ var Int8RangeExp = jet.Int8RangeExp

+ var MINUS_INFINITY = jet.MINUS_INFINITY

+ var NUM_RANGE = jet.NumRange

+ var NumRangeExp = jet.NumRangeExp

+ var NumericRangeColumn = jet.RangeColumn[NumericExpression]

+ var PLUS_INFINITY = jet.PLUS_INFINITY

+ var RawDateRange = jet.RawRange[jet.DateExpression]

+ var RawInt4Range = jet.RawRange[jet.Int4Expression]

+ var RawInt8Range = jet.RawRange[jet.Int8Expression]

+ var RawNumRange = jet.RawRange[jet.NumericExpression]

+ var RawTimestampRange = jet.RawRange[jet.TimestampExpression]

+ var RawTimestampzRange = jet.RawRange[jet.TimestampzExpression]

+ var TSTZ_RANGE = jet.TstzRange

+ var TS_RANGE = jet.TsRange

+ var TimestampRangeColumn = jet.RangeColumn[TimestampExpression]

+ var TimestampzRangeColumn = jet.RangeColumn[TimestampzExpression]

+ var TsRangeExp = jet.TsRangeExp

+ var TstzRangeExp = jet.TstzRangeExp

+ func LOWER_BOUND[T Expression](expression jet.Range[T]) T

+ func UPPER_BOUND[T Expression](expression jet.Range[T]) T

+ type ColumnDateRange = jet.ColumnRange[DateExpression]

+ type ColumnInt4Range jet.ColumnRange[jet.Int4Expression]

+ type ColumnInt8Range jet.ColumnRange[jet.Int8Expression]

+ type ColumnNumericRange = jet.ColumnRange[NumericExpression]

+ type ColumnTimestampRange = jet.ColumnRange[TimestampExpression]

+ type ColumnTimestampzRange = jet.ColumnRange[TimestampzExpression]

+ type DateRange = jet.Range[DateExpression]

+ type Int4Range = jet.Range[IntegerExpression]

+ type Int8Range = jet.Range[IntegerExpression]

+ type NumericRange = jet.Range[NumericExpression]

type SelectStatement

+ FETCH_FIRST func(count IntegerExpression) fetchExpand

+ OFFSET_e func(offset IntegerExpression) SelectStatement

+ type TimestampRange = jet.Range[TimestampExpression]

+ type TimestampzRange = jet.Range[TimestampzExpression]

v2.10.1

Jul 24, 2023

Changes in this version

+ var RawBool = jet.RawBool

+ type Rows = jet.Rows

v2.10.0

Apr 17, 2023

Changes in this version

+ var CUBE = jet.CUBE

+ var GROUPING = jet.GROUPING

+ var GROUPING_SETS = jet.GROUPING_SETS

+ var ROLLUP = jet.ROLLUP

+ var WRAP = jet.WRAP

v2.9.0

Sep 30, 2022

Changes in this version

type StringExpression

+ func Json(value interface{}) StringExpression

v2.8.0

May 17, 2022

Changes in this version

+ const DOW

+ const DOY

+ const EPOCH

+ const ISODOW

+ const ISOYEAR

+ const JULIAN

+ const QUARTER

+ const TIMEZONE

+ const TIMEZONE_HOUR

+ const TIMEZONE_MINUTE

type FloatExpression

+ func EXTRACT(field unit, from Expression) FloatExpression

v2.7.1

Feb 14, 2022

Changes in this version

+ var AND = jet.AND

+ var OR = jet.OR

v2.7.0

Jan 20, 2022

Changes in this version

+ var DISTINCT = jet.DISTINCT

+ var MODE = jet.MODE

+ var SetQueryLogger = jet.SetQueryLogger

+ func PERCENTILE_CONT(fraction FloatExpression) *jet.OrderSetAggregateFunc

+ func PERCENTILE_DISC(fraction FloatExpression) *jet.OrderSetAggregateFunc

+ func WITH_RECURSIVE(cte ...CommonTableExpression) func(statement jet.Statement) Statement

type CommonTableExpression

+ ALIAS func(alias string) SelectTable

+ AS func(statement jet.SerializerStatement) CommonTableExpression

+ AS_NOT_MATERIALIZED func(statement jet.SerializerStatement) CommonTableExpression

type DeleteStatement

+ USING func(tables ...ReadableTable) DeleteStatement

type IntervalExpression

+ BETWEEN func(min, max IntervalExpression) BoolExpression

+ NOT_BETWEEN func(min, max IntervalExpression) BoolExpression

+ type QueryInfo = jet.QueryInfo

type UpdateStatement

+ FROM func(tables ...ReadableTable) UpdateStatement

v2.6.0

Oct 25, 2021

Changes in this version

+ type GroupByClause = jet.GroupByClause

v2.5.0

May 21, 2021

Changes in this version

+ var Decimal = jet.Decimal

+ var Func = jet.Func

+ var Int16 = jet.Int16

+ var Int32 = jet.Int32

+ var Int64 = jet.Int

+ var Int8 = jet.Int8

+ var RawDate = jet.RawDate

+ var RawFloat = jet.RawFloat

+ var RawInt = jet.RawInt

+ var RawString = jet.RawString

+ var RawTime = jet.RawTime

+ var RawTimestamp = jet.RawTimestamp

+ var RawTimestampz = jet.RawTimestampz

+ var RawTimez = jet.RawTimez

+ var UUID = jet.UUID

+ var Uint16 = jet.Uint16

+ var Uint32 = jet.Uint32

+ var Uint64 = jet.Uint64

+ var Uint8 = jet.Uint8

+ func LATERAL(selectStmt SelectStatement) lateralImpl

+ type OrderByClause = jet.OrderByClause

+ type RawArgs = map[string]interface

type Statement

+ func RawStatement(rawQuery string, namedArguments ...RawArgs) Statement

v2.4.0

Jun 28, 2020

Changes in this version

+ const CENTURY

+ const DAY

+ const DECADE

+ const DEFAULT

+ const HOUR

+ const MICROSECOND

+ const MILLENNIUM

+ const MILLISECOND

+ const MINUTE

+ const MONTH

+ const SECOND

+ const WEEK

+ const YEAR

+ var ABSf = jet.ABSf

+ var ABSi = jet.ABSi

+ var AVG = jet.AVG

+ var BIT_AND = jet.BIT_AND

+ var BIT_LENGTH = jet.BIT_LENGTH

+ var BIT_NOT = jet.BIT_NOT

+ var BIT_OR = jet.BIT_OR

+ var BOOL_AND = jet.BOOL_AND

+ var BOOL_OR = jet.BOOL_OR

+ var BTRIM = jet.BTRIM

+ var Bool = jet.Bool

+ var BoolColumn = jet.BoolColumn

+ var BoolExp = jet.BoolExp

+ var Bytea = func(value string) StringExpression

+ var CASE = jet.CASE

+ var CBRT = jet.CBRT

+ var CEIL = jet.CEIL

+ var CHAR_LENGTH = jet.CHAR_LENGTH

+ var CHR = jet.CHR

+ var COALESCE = jet.COALESCE

+ var CONCAT = func(expressions ...Expression) StringExpression

+ var CONVERT = jet.CONVERT

+ var CONVERT_FROM = jet.CONVERT_FROM

+ var CONVERT_TO = jet.CONVERT_TO

+ var COUNT = jet.COUNT

+ var CUME_DIST = jet.CUME_DIST

+ var CURRENT_DATE = jet.CURRENT_DATE

+ var CURRENT_ROW = jet.CURRENT_ROW

+ var CURRENT_TIME = jet.CURRENT_TIME

+ var CURRENT_TIMESTAMP = jet.CURRENT_TIMESTAMP

+ var DECODE = jet.DECODE

+ var DENSE_RANK = jet.DENSE_RANK

+ var Date = func(year int, month time.Month, day int) DateExpression

+ var DateColumn = jet.DateColumn

+ var DateExp = jet.DateExp

+ var DateT = func(t time.Time) DateExpression

+ var Dialect = newDialect()

+ var ENCODE = jet.ENCODE

+ var EVERY = jet.EVERY

+ var EXISTS = jet.EXISTS

+ var FIRST_VALUE = jet.FIRST_VALUE

+ var FLOOR = jet.FLOOR

+ var Float = jet.Float

+ var FloatColumn = jet.FloatColumn

+ var FloatExp = jet.FloatExp

+ var GREATEST = jet.GREATEST

+ var INITCAP = jet.INITCAP

+ var Int = jet.Int

+ var IntExp = jet.IntExp

+ var IntegerColumn = jet.IntegerColumn

+ var KEY_SHARE = jet.NewRowLock("KEY SHARE")

+ var LAG = jet.LAG

+ var LAST_VALUE = jet.LAST_VALUE

+ var LEAD = jet.LEAD

+ var LEAST = jet.LEAST

+ var LEFT = jet.LEFT

+ var LENGTH = jet.LENGTH

+ var LN = jet.LN

+ var LOCALTIME = jet.LOCALTIME

+ var LOCALTIMESTAMP = jet.LOCALTIMESTAMP

+ var LOG = jet.LOG

+ var LOWER = jet.LOWER

+ var LPAD = jet.LPAD

+ var LTRIM = jet.LTRIM

+ var MAX = jet.MAX

+ var MAXf = jet.MAXf

+ var MAXi = jet.MAXi

+ var MD5 = jet.MD5

+ var MIN = jet.MIN

+ var MINf = jet.MINf

+ var MINi = jet.MINi

+ var NOT = jet.NOT

+ var NOW = jet.NOW

+ var NO_KEY_UPDATE = jet.NewRowLock("NO KEY UPDATE")

+ var NTH_VALUE = jet.NTH_VALUE

+ var NTILE = jet.NTILE

+ var NULL = jet.NULL

+ var NULLIF = jet.NULLIF

+ var NewEnumValue = jet.NewEnumValue

+ var OCTET_LENGTH = jet.OCTET_LENGTH

+ var ORDER_BY = jet.ORDER_BY

+ var PARTITION_BY = jet.PARTITION_BY

+ var PERCENT_RANK = jet.PERCENT_RANK

+ var POW = jet.POW

+ var POWER = jet.POWER

+ var RANK = jet.RANK

+ var REPEAT = jet.REPEAT

+ var REPLACE = jet.REPLACE

+ var REVERSE = jet.REVERSE

+ var RIGHT = jet.RIGHT

+ var ROUND = jet.ROUND

+ var ROW = jet.ROW

+ var ROW_NUMBER = jet.ROW_NUMBER

+ var RPAD = jet.RPAD

+ var RTRIM = jet.RTRIM

+ var Raw = jet.Raw

+ var SHARE = jet.NewRowLock("SHARE")

+ var SIGN = jet.SIGN

+ var SQRT = jet.SQRT

+ var STAR = jet.STAR

+ var STRPOS = jet.STRPOS

+ var SUBSTR = jet.SUBSTR

+ var SUM = jet.SUM

+ var SUMf = jet.SUMf

+ var SUMi = jet.SUMi

+ var SetLogger = jet.SetLoggerFunc

+ var String = jet.String

+ var StringColumn = jet.StringColumn

+ var StringExp = jet.StringExp

+ var TO_ASCII = jet.TO_ASCII

+ var TO_CHAR = jet.TO_CHAR

+ var TO_DATE = jet.TO_DATE

+ var TO_HEX = jet.TO_HEX

+ var TO_NUMBER = jet.TO_NUMBER

+ var TO_TIMESTAMP = jet.TO_TIMESTAMP

+ var TRUNC = jet.TRUNC

+ var Time = func(hour, minute, second int, nanoseconds ...time.Duration) TimeExpression

+ var TimeColumn = jet.TimeColumn

+ var TimeExp = jet.TimeExp

+ var TimeT = func(t time.Time) TimeExpression

+ var Timestamp = func(year int, month time.Month, day, hour, minute, second int, ...) TimestampExpression

+ var TimestampColumn = jet.TimestampColumn

+ var TimestampExp = jet.TimestampExp

+ var TimestampT = func(t time.Time) TimestampExpression

+ var Timestampz = func(year int, month time.Month, day, hour, minute, second int, ...) TimestampzExpression

+ var TimestampzColumn = jet.TimestampzColumn

+ var TimestampzExp = jet.TimestampzExp

+ var TimestampzT = func(t time.Time) TimestampzExpression

+ var Timez = func(hour, minute, second int, milliseconds time.Duration, timezone string) TimezExpression

+ var TimezColumn = jet.TimezColumn

+ var TimezExp = jet.TimezExp

+ var TimezT = func(t time.Time) TimezExpression

+ var UNBOUNDED = int64(math.MaxInt64)

+ var UPDATE = jet.NewRowLock("UPDATE")

+ var UPPER = jet.UPPER

+ var Window = jet.WindowName

+ func CAST(expr Expression) cast

+ func EXCEPT(lhs, rhs jet.SerializerStatement) setStatement

+ func EXCEPT_ALL(lhs, rhs jet.SerializerStatement) setStatement

+ func FOLLOWING(offset int64) jet.FrameExtent

+ func INTERSECT(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement

+ func INTERSECT_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement

+ func PRECEDING(offset int64) jet.FrameExtent

+ func SET(assigments ...ColumnAssigment) conflictAction

+ func UNION(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement

+ func UNION_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement

+ func WITH(cte ...jet.CommonTableExpressionDefinition) func(statement jet.Statement) Statement

+ type BoolExpression = jet.BoolExpression

+ type Column = jet.ColumnExpression

+ type ColumnAssigment = jet.ColumnAssigment

+ type ColumnBool = jet.ColumnBool

+ type ColumnDate = jet.ColumnDate

+ type ColumnFloat = jet.ColumnFloat

+ type ColumnInteger = jet.ColumnInteger

+ type ColumnInterval interface

+ From func(subQuery SelectTable) ColumnInterval

+ func IntervalColumn(name string) ColumnInterval

+ type ColumnList = jet.ColumnList

+ type ColumnString = jet.ColumnString

+ type ColumnTime = jet.ColumnTime

+ type ColumnTimestamp = jet.ColumnTimestamp

+ type ColumnTimestampz = jet.ColumnTimestampz

+ type ColumnTimez = jet.ColumnTimez

+ type CommonTableExpression struct

+ func CTE(name string) CommonTableExpression

+ func (r CommonTableExpression) CROSS_JOIN(table ReadableTable) ReadableTable

+ func (r CommonTableExpression) FULL_JOIN(table ReadableTable, onCondition BoolExpression) ReadableTable

+ func (r CommonTableExpression) INNER_JOIN(table ReadableTable, onCondition BoolExpression) ReadableTable

+ func (r CommonTableExpression) LEFT_JOIN(table ReadableTable, onCondition BoolExpression) ReadableTable

+ func (r CommonTableExpression) RIGHT_JOIN(table ReadableTable, onCondition BoolExpression) ReadableTable

+ func (r CommonTableExpression) SELECT(projection1 Projection, projections ...Projection) SelectStatement

+ type DateExpression = jet.DateExpression

+ type DeleteStatement interface

+ RETURNING func(projections ...jet.Projection) DeleteStatement

+ WHERE func(expression BoolExpression) DeleteStatement

+ type Expression = jet.Expression

+ type FloatExpression = jet.FloatExpression

+ type InsertStatement interface

+ MODEL func(data interface{}) InsertStatement

+ MODELS func(data interface{}) InsertStatement

+ ON_CONFLICT func(indexExpressions ...jet.ColumnExpression) onConflict

+ QUERY func(selectStatement SelectStatement) InsertStatement

+ RETURNING func(projections ...Projection) InsertStatement

+ VALUES func(value interface{}, values ...interface{}) InsertStatement

+ type IntegerExpression = jet.IntegerExpression

+ type IntervalExpression interface

+ ADD func(rhs IntervalExpression) IntervalExpression

+ DIV func(rhs NumericExpression) IntervalExpression

+ EQ func(rhs IntervalExpression) BoolExpression

+ GT func(rhs IntervalExpression) BoolExpression

+ GT_EQ func(rhs IntervalExpression) BoolExpression

+ IS_DISTINCT_FROM func(rhs IntervalExpression) BoolExpression

+ IS_NOT_DISTINCT_FROM func(rhs IntervalExpression) BoolExpression

+ LT func(rhs IntervalExpression) BoolExpression

+ LT_EQ func(rhs IntervalExpression) BoolExpression

+ MUL func(rhs NumericExpression) IntervalExpression

+ NOT_EQ func(rhs IntervalExpression) BoolExpression

+ SUB func(rhs IntervalExpression) IntervalExpression

+ func INTERVAL(quantityAndUnit ...quantityAndUnit) IntervalExpression

+ func INTERVALd(duration time.Duration) IntervalExpression

+ func IntervalExp(expression Expression) IntervalExpression

+ type LockStatement interface

+ IN func(lockMode TableLockMode) LockStatement

+ NOWAIT func() LockStatement

+ func LOCK(tables ...jet.SerializerTable) LockStatement

+ type NumericExpression = jet.NumericExpression

+ type PrintableStatement = jet.PrintableStatement

+ type Projection = jet.Projection

+ type ProjectionList = jet.ProjectionList

+ type ReadableTable interface

+ type RowLock = jet.RowLock

+ type SelectStatement interface

+ AsTable func(alias string) SelectTable

+ DISTINCT func() SelectStatement

+ EXCEPT func(rhs SelectStatement) setStatement

+ EXCEPT_ALL func(rhs SelectStatement) setStatement

+ FOR func(lock RowLock) SelectStatement

+ FROM func(table ReadableTable) SelectStatement

+ GROUP_BY func(groupByClauses ...jet.GroupByClause) SelectStatement

+ HAVING func(boolExpression BoolExpression) SelectStatement

+ INTERSECT func(rhs SelectStatement) setStatement

+ INTERSECT_ALL func(rhs SelectStatement) setStatement

+ LIMIT func(limit int64) SelectStatement

+ OFFSET func(offset int64) SelectStatement

+ ORDER_BY func(orderByClauses ...jet.OrderByClause) SelectStatement

+ UNION func(rhs SelectStatement) setStatement

+ UNION_ALL func(rhs SelectStatement) setStatement

+ WHERE func(expression BoolExpression) SelectStatement

+ WINDOW func(name string) windowExpand

+ func SELECT(projection Projection, projections ...Projection) SelectStatement

+ type SelectTable interface

+ type Statement = jet.Statement

+ type StringExpression = jet.StringExpression

+ func CONCAT_WS(separator Expression, expressions ...Expression) StringExpression

+ func FORMAT(formatStr StringExpression, formatArgs ...Expression) StringExpression

+ type Table interface

+ func NewTable(schemaName, name string, columns ...jet.ColumnExpression) Table

+ type TableLockMode string

+ const LOCK_ACCESS_EXCLUSIVE

+ const LOCK_ACCESS_SHARE

+ const LOCK_EXCLUSIVE

+ const LOCK_ROW_EXCLUSIVE

+ const LOCK_ROW_SHARE

+ const LOCK_SHARE

+ const LOCK_SHARE_ROW_EXCLUSIVE

+ const LOCK_SHARE_UPDATE_EXCLUSIVE

+ type TimeExpression = jet.TimeExpression

+ type TimestampExpression = jet.TimestampExpression

+ type TimestampzExpression = jet.TimestampzExpression

+ type TimezExpression = jet.TimezExpression

+ type UpdateStatement interface

+ MODEL func(data interface{}) UpdateStatement

+ RETURNING func(projections ...jet.Projection) UpdateStatement

+ SET func(value interface{}, values ...interface{}) UpdateStatement

+ WHERE func(expression BoolExpression) UpdateStatement

+ type WritableTable interface

Other modules containing this package

github.com/go-jet/jet

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL