Package-level declarations
Types
SqlType implementation represents PostgreSQL boolean[] type.
Bulk insert expression, represents a bulk insert statement in PostgreSQL.
DSL builder for bulk insert or update statements.
DSL builder for bulk insert statements.
Represents a box suitable for an indexed search using the cube @> operator. Part of PostgreSQL cube SQL extension. https://www.postgresql.org/docs/9.5/cube.html
Expression class represents PostgreSQL Cube operations.
Enum for 'cube' and 'earthdistance' binary operators.
Represents a Cube by storing 2 n-dimensional points Part of PostgreSQL cube SQL extension. https://www.postgresql.org/docs/9.5/cube.html
SqlType implementation represents PostgreSQL float8[] type.
Cube-based earth abstraction, using 3 coordinates representing the x, y, and z distance from the center of the Earth. Part of PostgreSQL earthdistance SQL extension.
SqlType implementation represents PostgreSQL real[] type.
Expression class represents PostgreSQL hstore operations.
Enum for hstore operators.
SqlType implementation represents PostgreSQL hstore type.
ILike expression, represents PostgreSQL ilike keyword.
Insert or update expression, represents an insert statement with an on conflict (key) do update set clause in PostgreSQL.
DSL builder for insert or update on conflict clause.
DSL builder for insert or update statements.
SqlType implementation represents PostgreSQL integer[] type.
PostgreSQL locking clause. See https://www.postgresql.org/docs/13/sql-select.html#SQL-FOR-UPDATE-SHARE
PostgreSQL locking mode.
PostgreSQL wait strategy for locked records.
SqlType implementation represents PostgreSQL bigint[] type.
Base class of PostgreSQL DSL builders, provide basic functions used to build assignments for insert or update DSL.
SqlDialect implementation for PostgreSQL database.
Base interface designed to visit or modify PostgreSQL expression trees using visitor pattern.
SqlFormatter implementation for PostgreSQL, formatting SQL expressions as strings with their execution arguments.
SqlType implementation represents PostgreSQL smallint[] type.
SqlType implementation represents PostgreSQL text[] type.
Functions
Returns the subscript of the first occurrence of the second argument in the array, or NULL if it's not present. If the third argument is given, the search begins at that subscript. The array must be one-dimensional.
Define a column typed BooleanArraySqlType.
Construct a bulk insert expression in the given closure, then execute it and return the effected row count.
Bulk insert records to the table and return the effected row count.
Bulk insert records to the table, determining if there is a key conflict while inserting each of them, and automatically performs updates if any conflict exists.
Bulk insert records to the table, determining if there is a key conflict while inserting each of them, automatically performs updates if any conflict exists, and finally returns the specific columns.
Bulk insert records to the table, determining if there is a key conflict while inserting each of them, automatically performs updates if any conflict exists, and finally returns the specific column.
Bulk insert records to the table and return the specific columns' values.
Bulk insert records to the table and return the specific column's values.
Cube contained in operator, translated to the <@ operator in PostgreSQL.
HStore contained-in operator, translated to the <@ operator in PostgreSQL.
HStore contains operator, translated to the @> operator in PostgreSQL.
Cube contains operator, translated to the @> operator in PostgreSQL.
HStore contains-all-keys operator, translated to the ?& operator in PostgreSQL.
HStore contains-any-keys operator, translated to the ?| operator in PostgreSQL.
HStore contains-key operator, translated to the ? operator in PostgreSQL.
Return a default value for this column, see DefaultValueExpression.
Define a column typed DoubleArraySqlType.
Returns a box suitable for an indexed search using the cube @> operator for points within a given great circle distance of a location. Some points in this box are further than the specified great circle distance from the location, so a second check using earth_distance should be included in the query.
Returns the great circle distance between two points on the surface of the Earth.
Define a column typed FloatArraySqlType.
HStore get-values-for-keys operator, translated to the -> operator in PostgreSQL.
HStore get-value-for-key operator, translated to the -> operator in PostgreSQL.
ILike operator, translated to the ilike keyword in PostgreSQL.
Insert a record to the table, determining if there is a key conflict while it's being inserted, and automatically performs an update if any conflict exists.
Insert a record to the table, determining if there is a key conflict while it's being inserted, automatically performs an update if any conflict exists, and finally returns the specific columns.
Insert a record to the table, determining if there is a key conflict while it's being inserted, automatically performs an update if any conflict exists, and finally returns the specific column.
Insert a record to the table and return the specific columns.
Insert a record to the table and return the specific column.
Returns the latitude in degrees of a point on the surface of the Earth.
Returns the location of a point on the surface of the Earth given its latitude (argument 1) and longitude (argument 2) in degrees.
Specify the locking clause of this query, an example generated SQL could be:
Returns the longitude in degrees of a point on the surface of the Earth.
HStore delete-keys operator, translated to the - operator in PostgreSQL.
HStore delete-key operator, translated to the - operator in PostgreSQL.
HStore delete-matching-pairs operator, translated to the - operator in PostgreSQL.
Cube overlap operator, translated to the && operator in PostgreSQL.
HStore concatenate operator, translated to the || operator in PostgreSQL.
Define a column typed ShortArraySqlType.
