pgsql

package

Go to main page

Versions in this module

v0

v0.4.8

Feb 10, 2026

v0.4.7

Feb 5, 2026

v0.4.6

Feb 5, 2026

v0.4.5

Jan 29, 2026

v0.4.4

Jan 29, 2026

v0.4.3

Jan 23, 2026

v0.4.2

Jan 15, 2026

v0.4.1

Jan 15, 2026

v0.4.0

Jan 14, 2026

v0.3.3

Jan 15, 2026

v0.3.2

Jan 5, 2026

v0.3.1

Dec 9, 2025

v0.3.0

Sep 10, 2025

v0.2.1

Aug 14, 2025

Changes in this version

type Identifier

+ const FunctionAvg

+ const FunctionSum

type RecordShape

+ func NewRecordShape(columns []Identifier) *RecordShape

v0.2.0

Jul 8, 2025

v0.1.6

Jul 1, 2025

v0.1.5

Jun 27, 2025

v0.1.4

Jun 27, 2025

Changes in this version

type Identifier

+ const StringLiteralEmptyArray

+ const StringLiteralNull

type Operator

+ const OperatorCypherNotEquals

v0.1.3

Jun 17, 2025

v0.1.2

Jun 17, 2025

v0.1.1

Jun 17, 2025

v0.1.0

Jun 17, 2025

Changes in this version

+ var CompositeTypes = []DataType

+ var EdgeTableColumns = []Identifier

+ var ErrNoAvailableArrayDataType = errors.New("data type has no direct array representation")

+ var NodeTableColumns = []Identifier

+ func AsOptionalIdentifier(identifier Identifier) models.Optional[Identifier]

+ func As[T any](node SyntaxNode) (T, error)

+ func IDSliceToInt8Array(value []graph.ID) (pgtype.Int8Array, error)

+ func Int32SliceToInt4Array(value []int32) (pgtype.Int4Array, error)

+ func IsAggregateFunction(function Identifier) bool

+ func IsReservedIdentifier(identifier Identifier) bool

+ func JSONBToProperties(jsonb pgtype.JSONB) (*graph.Properties, error)

+ func MapStringAnyToJSONB(values map[string]any) (pgtype.JSONB, error)

+ func MatcherAsJSONB(fieldName string, value any) (pgtype.JSONB, error)

+ func MustMatcherAsJSONB(fieldName string, value any) pgtype.JSONB

+ func NegotiateValue(value any) (any, error)

+ func OperatorIsBoolean(operator Expression) bool

+ func OperatorIsComparator(operator Expression) bool

+ func OperatorIsIn(operator Expression, matchers ...Expression) bool

+ func OperatorIsPropertyLookup(operator Expression) bool

+ func PropertiesToJSONB(properties *graph.Properties) (pgtype.JSONB, error)

+ func StringSliceToTextArray(values []string) (pgtype.TextArray, error)

+ func ValueToJSONB(value any) (pgtype.JSONB, error)

+ type AliasedExpression struct

+ Alias models.Optional[Identifier]

+ Expression Expression

+ func (s AliasedExpression) AsExpression() Expression

+ func (s AliasedExpression) AsSelectItem() SelectItem

+ func (s AliasedExpression) NodeType() string

+ type AllExpression struct

+ func NewAllExpression(inner Expression) AllExpression

+ type AnyExpression struct

+ CastType DataType

+ func NewAnyExpression(inner Expression, castType DataType) *AnyExpression

+ func NewAnyExpressionHinted(inner TypeHinted) *AnyExpression

+ func (s AnyExpression) AsExpression() Expression

+ func (s AnyExpression) NodeType() string

+ func (s AnyExpression) TypeHint() DataType

+ type ArrayExpression struct

+ Expression Expression

+ func (s ArrayExpression) AsExpression() Expression

+ func (s ArrayExpression) NodeType() string

+ type ArrayIndex struct

+ Expression Expression

+ Indexes []Expression

+ func (s ArrayIndex) AsExpression() Expression

+ func (s ArrayIndex) NodeType() string

+ type ArrayLiteral struct

+ CastType DataType

+ Values []Expression

+ func NewArrayLiteral[T any](values []T, castType DataType) (ArrayLiteral, error)

+ func (s ArrayLiteral) AsExpression() Expression

+ func (s ArrayLiteral) AsSelectItem() SelectItem

+ func (s ArrayLiteral) NodeType() string

+ func (s ArrayLiteral) TypeHint() DataType

+ type Assignment interface

+ AsAssignment func() Assignment

+ type Between struct

+ Expression Expression

+ High Expression

+ Low Expression

+ Negated bool

+ type BinaryExpression struct

+ LOperand Expression

+ Operator Operator

+ ROperand Expression

+ func NewBinaryExpression(left Expression, operator Operator, right Expression) *BinaryExpression

+ func NewJSONTextFieldLookup(reference CompoundIdentifier, field Identifier) *BinaryExpression

+ func NewPropertyLookup(identifier CompoundIdentifier, reference Literal) *BinaryExpression

+ func (s BinaryExpression) AsAssignment() Assignment

+ func (s BinaryExpression) AsExpression() Expression

+ func (s BinaryExpression) AsSelectItem() SelectItem

+ func (s BinaryExpression) NodeType() string

+ type Case struct

+ Conditions []Expression

+ Else Expression

+ Operand Expression

+ Then []Expression

+ type CommonTableExpression struct

+ Alias TableAlias

+ Materialized models.Optional[Materialized]

+ Query Query

+ func (s CommonTableExpression) NodeType() string

+ type CompositeValue struct

+ DataType DataType

+ Values []Expression

+ func (s CompositeValue) AsExpression() Expression

+ func (s CompositeValue) AsSelectItem() SelectItem

+ func (s CompositeValue) NodeType() string

+ type CompoundIdentifier []Identifier

+ func AsCompoundIdentifier[T string | Identifier](parts ...T) CompoundIdentifier

+ func (s CompoundIdentifier) AsExpression() Expression

+ func (s CompoundIdentifier) AsSelectItem() SelectItem

+ func (s CompoundIdentifier) Copy() CompoundIdentifier

+ func (s CompoundIdentifier) Field() Identifier

+ func (s CompoundIdentifier) HasField() bool

+ func (s CompoundIdentifier) IsBlank() bool

+ func (s CompoundIdentifier) NodeType() string

+ func (s CompoundIdentifier) Root() Identifier

+ func (s CompoundIdentifier) String() string

+ func (s CompoundIdentifier) Strings() []string

+ type ConflictAction interface

+ AsConflictAction func() ConflictAction

+ type ConflictTarget struct

+ Columns []Expression

+ Constraint CompoundIdentifier

+ func (s ConflictTarget) AsExpression() Expression

+ func (s ConflictTarget) NodeType() string

+ type DataType string

+ const Any

+ const AnyArray

+ const Boolean

+ const Date

+ const EdgeComposite

+ const EdgeCompositeArray

+ const ExpansionEdge

+ const ExpansionPath

+ const ExpansionPattern

+ const ExpansionRootNode

+ const ExpansionTerminalNode

+ const Float4

+ const Float4Array

+ const Float8

+ const Float8Array

+ const Int

+ const Int2

+ const Int2Array

+ const Int4

+ const Int4Array

+ const Int8

+ const Int8Array

+ const IntArray

+ const Interval

+ const JSONB

+ const JSONBArray

+ const NodeComposite

+ const NodeCompositeArray

+ const Null

+ const Numeric

+ const NumericArray

+ const ParameterIdentifier

+ const PathComposite

+ const Scope

+ const Text

+ const TextArray

+ const TimeWithTimeZone

+ const TimeWithoutTimeZone

+ const TimestampWithTimeZone

+ const TimestampWithoutTimeZone

+ const UnknownDataType

+ const UnsetDataType

+ func ValueToDataType(value any) (DataType, error)

+ func (s DataType) ArrayBaseType() DataType

+ func (s DataType) CoerceToSupertype(other DataType) (DataType, bool)

+ func (s DataType) IsArrayType() bool

+ func (s DataType) IsComparable(other DataType, operator Operator) bool

+ func (s DataType) IsKnown() bool

+ func (s DataType) MatchesOneOf(others ...DataType) bool

+ func (s DataType) NodeType() string

+ func (s DataType) OperatorResultType(other DataType, operator Operator) (DataType, bool)

+ func (s DataType) String() string

+ func (s DataType) ToArrayType() (DataType, error)

+ type Delete struct

+ From []TableReference

+ Returning []SelectItem

+ Using []FromClause

+ Where models.Optional[Expression]

+ func (s Delete) AsExpression() Expression

+ func (s Delete) AsSetExpression() SetExpression

+ func (s Delete) AsStatement() Statement

+ func (s Delete) NodeType() string

+ type DoNothing struct

+ type DoUpdate struct

+ Assignments []Assignment

+ Where Expression

+ func (s DoUpdate) AsConflictAction() ConflictAction

+ func (s DoUpdate) AsExpression() Expression

+ func (s DoUpdate) NodeType() string

+ type ExistsExpression struct

+ Negated bool

+ Subquery Subquery

+ func (s ExistsExpression) AsExpression() Expression

+ func (s ExistsExpression) AsSelectItem() SelectItem

+ func (s ExistsExpression) NodeType() string

+ type Expression interface

+ AsExpression func() Expression

+ func OptionalAnd(leftOperand Expression, rightOperand Expression) Expression

+ func OptionalBinaryExpressionJoin(optional Expression, operator Operator, conjoined Expression) Expression

+ type FormattingLiteral string

+ func (s FormattingLiteral) AsExpression() Expression

+ func (s FormattingLiteral) NodeType() string

+ func (s FormattingLiteral) String() string

+ type FromClause struct

+ Joins []Join

+ Source Expression

+ func (s FromClause) NodeType() string

+ type FunctionCall struct

+ Bare bool

+ CastType DataType

+ Distinct bool

+ Function Identifier

+ Over *Window

+ Parameters []Expression

+ func (s FunctionCall) AsAssignment() Assignment

+ func (s FunctionCall) AsExpression() Expression

+ func (s FunctionCall) AsSelectItem() SelectItem

+ func (s FunctionCall) NodeType() string

+ func (s FunctionCall) TypeHint() DataType

+ type Future struct

+ Data U

+ DataType DataType

+ SyntaxNode SyntaxNode

+ func NewFuture[U any](data U, dataType DataType) *Future[U]

+ func (s Future[U]) AsExpression() Expression

+ func (s Future[U]) NodeType() string

+ func (s Future[U]) Satisfied() bool

+ func (s Future[U]) TypeHint() DataType

+ func (s Future[U]) Unwrap() SyntaxNode

+ type Identifier string

+ const ColumnEndID

+ const ColumnGraphID

+ const ColumnID

+ const ColumnKindID

+ const ColumnKindIDs

+ const ColumnPath

+ const ColumnProperties

+ const ColumnStartID

+ const EpochIdentifier

+ const FunctionArrayAggregate

+ const FunctionArrayLength

+ const FunctionArrayRemove

+ const FunctionBidirectionalASPHarness

+ const FunctionCoalesce

+ const FunctionCount

+ const FunctionCurrentDate

+ const FunctionCurrentTime

+ const FunctionEdgesToPath

+ const FunctionExtract

+ const FunctionIntArraySort

+ const FunctionIntArrayUnique

+ const FunctionJSONBArrayElementsText

+ const FunctionJSONBArrayLength

+ const FunctionJSONBBuildObject

+ const FunctionJSONBSet

+ const FunctionJSONBToTextArray

+ const FunctionLocalTime

+ const FunctionLocalTimestamp

+ const FunctionMax

+ const FunctionMin

+ const FunctionNodesToPath

+ const FunctionNow

+ const FunctionStringToArray

+ const FunctionToLower

+ const FunctionToUpper

+ const FunctionUnidirectionalASPHarness

+ const FunctionUnidirectionalSPHarness

+ const FunctionUnnest

+ const TableEdge

+ const TableNode

+ const WildcardIdentifier

+ func AsIdentifiers(strs ...string) []Identifier

+ func (s Identifier) AsCompoundIdentifier() CompoundIdentifier

+ func (s Identifier) AsExpression() Expression

+ func (s Identifier) AsSelectItem() SelectItem

+ func (s Identifier) Matches(others ...Identifier) bool

+ func (s Identifier) NodeType() string

+ func (s Identifier) String() string

+ type IdentifierSet struct

+ func AllocateIdentifierSet(length int) *IdentifierSet

+ func AsIdentifierSet(identifiers ...Identifier) *IdentifierSet

+ func NewIdentifierSet() *IdentifierSet

+ func (s *IdentifierSet) Add(identifiers ...Identifier) *IdentifierSet

+ func (s *IdentifierSet) CheckedAdd(identifier Identifier) bool

+ func (s *IdentifierSet) Clear()

+ func (s *IdentifierSet) CombinedKey() Identifier

+ func (s *IdentifierSet) Contains(other Identifier) bool

+ func (s *IdentifierSet) Copy() *IdentifierSet

+ func (s *IdentifierSet) IsEmpty() bool

+ func (s *IdentifierSet) Len() int

+ func (s *IdentifierSet) Matches(other *IdentifierSet) bool

+ func (s *IdentifierSet) MergeSet(other *IdentifierSet) *IdentifierSet

+ func (s *IdentifierSet) Remove(others ...Identifier) *IdentifierSet

+ func (s *IdentifierSet) RemoveSet(other *IdentifierSet) *IdentifierSet

+ func (s *IdentifierSet) Satisfies(other *IdentifierSet) bool

+ func (s *IdentifierSet) Slice() []Identifier

+ func (s *IdentifierSet) Strings() []string

+ type InExpression struct

+ Expression Expression

+ List []Expression

+ Negated bool

+ type InSubquery struct

+ Expression Expression

+ Negated bool

+ Query Query

+ type Insert struct

+ OnConflict *OnConflict

+ Returning []SelectItem

+ Shape RecordShape

+ Source *Query

+ Table TableReference

+ func (s Insert) AsStatement() Statement

+ func (s Insert) NodeType() string

+ type Join struct

+ JoinOperator JoinOperator

+ Table TableReference

+ func (s Join) NodeType() string

+ type JoinOperator struct

+ Constraint Expression

+ JoinType JoinType

+ func (s JoinOperator) NodeType() string

+ type JoinType int

+ const JoinTypeFullOuter

+ const JoinTypeInner

+ const JoinTypeLeftOuter

+ const JoinTypeRightOuter

+ type KindListLiteral struct

+ Values graph.Kinds

+ func (s KindListLiteral) AsExpression() Expression

+ func (s KindListLiteral) NodeType() string

+ type KindMapper interface

+ AssertKinds func(ctx context.Context, kinds graph.Kinds) ([]int16, error)

+ MapKinds func(ctx context.Context, kinds graph.Kinds) ([]int16, error)

+ type Literal struct

+ CastType DataType

+ Null bool

+ Value any

+ func AsLiteral(value any) (Literal, error)

+ func NewLiteral(value any, dataType DataType) Literal

+ func NullLiteral() Literal

+ func (s Literal) AsExpression() Expression

+ func (s Literal) AsSelectItem() SelectItem

+ func (s Literal) NodeType() string

+ func (s Literal) TypeHint() DataType

+ type LiteralNodeValue struct

+ CastType DataType

+ Null bool

+ Value any

+ type MatchedDelete struct

+ Predicate Expression

+ func (s MatchedDelete) AsExpression() Expression

+ func (s MatchedDelete) AsMergeAction() MergeAction

+ func (s MatchedDelete) NodeType() string

+ type MatchedUpdate struct

+ Assignments []Assignment

+ Predicate Expression

+ func (s MatchedUpdate) AsExpression() Expression

+ func (s MatchedUpdate) AsMergeAction() MergeAction

+ func (s MatchedUpdate) NodeType() string

+ type Materialized struct

+ Materialized bool

+ func (s Materialized) AsExpression() Expression

+ func (s Materialized) AsSetExpression() SetExpression

+ func (s Materialized) NodeType() string

+ type Merge struct

+ Actions []MergeAction

+ Into bool

+ JoinTarget Expression

+ Source TableReference

+ Table TableReference

+ func (s Merge) AsStatement() Statement

+ func (s Merge) NodeType() string

+ type MergeAction interface

+ AsMergeAction func() MergeAction

+ type OnConflict struct

+ Action ConflictAction

+ Target *ConflictTarget

+ func (s OnConflict) AsExpression() Expression

+ func (s OnConflict) NodeType() string

+ type Operator string

+ const OperatorAdd

+ const OperatorAdditionAssignment

+ const OperatorAnd

+ const OperatorArrayOverlap

+ const OperatorAssignment

+ const OperatorConcatenate

+ const OperatorCypherContains

+ const OperatorCypherEndsWith

+ const OperatorCypherRegexMatch

+ const OperatorCypherStartsWith

+ const OperatorDivide

+ const OperatorEquals

+ const OperatorGreaterThan

+ const OperatorGreaterThanOrEqualTo

+ const OperatorILike

+ const OperatorIn

+ const OperatorIs

+ const OperatorIsNot

+ const OperatorJSONBFieldExists

+ const OperatorJSONField

+ const OperatorJSONTextField

+ const OperatorKindAssignment

+ const OperatorLessThan

+ const OperatorLessThanOrEqualTo

+ const OperatorLike

+ const OperatorMultiply

+ const OperatorNot

+ const OperatorNotEquals

+ const OperatorOr

+ const OperatorPGArrayOverlap

+ const OperatorPropertyLookup

+ const OperatorRegexMatch

+ const OperatorSimilarTo

+ const OperatorSubtract

+ const OperatorUnion

+ const UnsetOperator

+ func (s Operator) AsExpression() Expression

+ func (s Operator) IsIn(others ...Operator) bool

+ func (s Operator) NodeType() string

+ func (s Operator) String() string

+ type OrderBy struct

+ Ascending bool

+ Expression Expression

+ func NewOrderBy(ascending bool) *OrderBy

+ func (s OrderBy) AsExpression() Expression

+ func (s OrderBy) NodeType() string

+ type Parameter struct

+ CastType DataType

+ Identifier Identifier

+ func AsParameter(identifier Identifier, value any) (*Parameter, error)

+ func (s Parameter) AsExpression() Expression

+ func (s Parameter) AsSelectItem() SelectItem

+ func (s Parameter) NodeType() string

+ func (s Parameter) TypeHint() DataType

+ type Parenthetical struct

+ Expression Expression

+ func NewParenthetical(expr Expression) *Parenthetical

+ func (s *Parenthetical) AsExpression() Expression

+ func (s *Parenthetical) AsSelectItem() SelectItem

+ func (s *Parenthetical) NodeType() string

+ type Projection []SelectItem

+ func (s Projection) AsExpression() Expression

+ func (s Projection) AsSyntaxNodes() []SyntaxNode

+ func (s Projection) NodeType() string

+ type ProjectionFrom struct

+ From []FromClause

+ Projection Projection

+ func (s ProjectionFrom) AsExpression() Expression

+ func (s ProjectionFrom) NodeType() string

+ type Query struct

+ Body SetExpression

+ CommonTableExpressions *With

+ Limit models.Optional[Expression]

+ Offset models.Optional[Expression]

+ OrderBy []*OrderBy

+ func (s Query) AddCTE(cte CommonTableExpression)

+ func (s Query) AsExpression() Expression

+ func (s Query) AsSetExpression() SetExpression

+ func (s Query) AsStatement() Statement

+ func (s Query) NodeType() string

+ type RecordShape struct

+ Columns []Identifier

+ func (s RecordShape) NodeType() string

+ type RowColumnReference struct

+ Column Identifier

+ Identifier Expression

+ func (s RowColumnReference) AsExpression() Expression

+ func (s RowColumnReference) AsSelectItem() SelectItem

+ func (s RowColumnReference) NodeType() string

+ type Select struct

+ Distinct bool

+ From []FromClause

+ GroupBy []Expression

+ Having Expression

+ Projection Projection

+ Where Expression

+ func (s Select) AsExpression() Expression

+ func (s Select) AsSetExpression() SetExpression

+ func (s Select) NodeType() string

+ type SelectItem interface

+ AsSelectItem func() SelectItem

+ type SetExpression interface

+ AsSetExpression func() SetExpression

+ type SetOperation struct

+ All bool

+ Distinct bool

+ LOperand SetExpression

+ Operator Operator

+ ROperand SetExpression

+ func (s SetOperation) AsExpression() Expression

+ func (s SetOperation) AsSetExpression() SetExpression

+ func (s SetOperation) NodeType() string

+ type Statement interface

+ AsStatement func() Statement

+ type Subquery struct

+ Query Query

+ func (s Subquery) AsExpression() Expression

+ func (s Subquery) NodeType() string

+ type SymbolTable struct

+ func NewSymbolTable() *SymbolTable

+ func (s *SymbolTable) Add(symbol any)

+ func (s *SymbolTable) AddCompoundIdentifier(identifier CompoundIdentifier)

+ func (s *SymbolTable) AddIdentifier(identifier Identifier)

+ func (s *SymbolTable) AddTable(symbols *SymbolTable)

+ func (s *SymbolTable) Contains(symbol any) bool

+ func (s *SymbolTable) EachCompoundIdentifier(each func(next CompoundIdentifier) bool)

+ func (s *SymbolTable) EachIdentifier(each func(next Identifier) bool)

+ func (s *SymbolTable) IsEmpty() bool

+ func (s *SymbolTable) NotIn(exclusions *SymbolTable) *SymbolTable

+ func (s *SymbolTable) RootIdentifiers() *IdentifierSet

+ type SyntaxNode interface

+ NodeType func() string

+ type SyntaxNodeFuture interface

+ Satisfied func() bool

+ Unwrap func() SyntaxNode

+ type TableAlias struct

+ Name Identifier

+ Shape models.Optional[RecordShape]

+ func (s TableAlias) NodeType() string

+ type TableReference struct

+ Binding models.Optional[Identifier]

+ Name CompoundIdentifier

+ func (s TableReference) AsExpression() Expression

+ func (s TableReference) NodeType() string

+ type TypeCast struct

+ CastType DataType

+ Expression Expression

+ func (s TypeCast) AsExpression() Expression

+ func (s TypeCast) NodeType() string

+ func (s TypeCast) TypeHint() DataType

+ type TypeHinted interface

+ TypeHint func() DataType

+ func NewTypeCast(expression Expression, dataType DataType) TypeHinted

+ type UnaryExpression struct

+ Operand Expression

+ Operator Expression

+ func NewUnaryExpression(operator Operator, operand Expression) *UnaryExpression

+ func (s UnaryExpression) AsExpression() Expression

+ func (s UnaryExpression) NodeType() string

+ type UnmatchedAction struct

+ Columns []Identifier

+ Predicate Expression

+ Values Values

+ func (s UnmatchedAction) AsExpression() Expression

+ func (s UnmatchedAction) AsMergeAction() MergeAction

+ func (s UnmatchedAction) NodeType() string

+ type Update struct

+ Assignments []Assignment

+ From []FromClause

+ Returning []SelectItem

+ Table TableReference

+ Where models.Optional[Expression]

+ func (s Update) AsExpression() Expression

+ func (s Update) AsSetExpression() SetExpression

+ func (s Update) AsStatement() Statement

+ func (s Update) NodeType() string

+ type Values struct

+ Values []Expression

+ func (s Values) AsExpression() Expression

+ func (s Values) AsSetExpression() SetExpression

+ func (s Values) NodeType() string

+ type Variadic struct

+ Expression Expression

+ func (s Variadic) AsExpression() Expression

+ func (s Variadic) NodeType() string

+ type Wildcard struct

+ func (s Wildcard) AsExpression() Expression

+ func (s Wildcard) AsSelectItem() SelectItem

+ func (s Wildcard) NodeType() string

+ type Window struct

+ OrderBy []OrderBy

+ PartitionBy []Expression

+ WindowFrame *WindowFrame

+ type WindowFrame struct

+ EndBoundary *WindowFrameBoundary

+ StartBoundary WindowFrameBoundary

+ Unit WindowFrameUnit

+ type WindowFrameBoundary struct

+ BoundaryLiteral *Literal

+ BoundaryType WindowFrameBoundaryType

+ type WindowFrameBoundaryType int

+ const WindowFrameBoundaryTypeCurrentRow

+ const WindowFrameBoundaryTypeFollowing

+ const WindowFrameBoundaryTypePreceding

+ type WindowFrameUnit int

+ const WindowFrameUnitGroups

+ const WindowFrameUnitRange

+ const WindowFrameUnitRows

+ type With struct

+ Expressions []CommonTableExpression

+ Recursive bool

+ func (s With) NodeType() string

+ type WrappedNode interface

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