All Classes and Interfaces
Class
Description
A class demonstrating several aggregate functions.
Provides example methods to illustrate the polymorphic types
any,
anyarray, and anyelement.Example using
ResultSetProvider to return 100 rows of two
bytea columns each, which should be equal in each row, one being
set by updateBinaryStream
and the other by updateBytes.Complex (re and im parts are doubles) implemented in Java as a scalar UDT.
Complex (re and im parts are doubles) implemented in Java as a mapped UDT.
Test of a very simple form of conditional execution in the deployment
descriptor using only the
<implementor name> specified for an
<implementor block>.Confirms the mapping of PG enum and Java String, and arrays of each, as
parameter and return types.
Demonstrate holdability of ResultSets (test for issue 168).
Example implementing
ResultSetProvider to provide a function that
generates and returns a lot of rows (caller passes the desired row count)
each containing the row number, a random integer, and a timestamp.An integer-like data type accepting a type modifier: IntWithMod(even) or
IntWithMod(odd).
Exercise new mappings between date/time types and java.time classes
(JDBC 4.2 change 21).
Provides a function to log, at the specified level, a specified message.
Example returning (varchar,boolean) rows, one for each boolean-valued
attribute in the JDBC
DatabaseMetaData.Example returning (varchar,int) rows, one for each int-valued
attribute in the JDBC
DatabaseMetaData.Example returning (varchar,varchar) rows, one for each String-valued
attribute in the JDBC
DatabaseMetaData.Provides a
callMetaData function taking a string
that supplies the name of, and arguments to, any ResultSet-returning
DatabaseMetaData method, and returns a single-column varchar
result, the first row a header, then one for each ResultSet row,
semicolons delimiting the original columns.Example code to support querying for the modules in Java's boot layer.
Illustrates PL/Java functions on an interface instead of a class.
Some methods used for testing parameter and return value coersion and
resolution of overloaded methods.
Class illustrating use of
SQLXML to operate on XML data.Class that will mock an
SQLXML instance, returning only binary or
character stream data from a byte array or string supplied at
construction.Class that will proxy methods to another
SQLXML class.A gnarly test of TupleDesc reference management, crafted by Johann Oskarsson
for bug report 1010962 on pgFoundry.
Example of a "mirrored UDT": a user-defined type that exposes to Java the
internal representation of an existing (but not SQL-standard) PostgreSQL
type.
Some tests of pre-JSR 310 date/time/timestamp conversions.
Provides a
function producing as many rows as
requested, each with a random int.Example demonstrating the use of a
RECORD parameter as a way to
supply an arbitrary sequence of named, typed parameters to a PL/Java
function.Provides a
function that takes any SQL SELECT
query as a string, executes it, and returns the ResultSet produced
as a single string column, the first row being a header, then one per row
of the ResultSet, semicolons delimiting the original columns.Demonstrates
@Function(out={...}) for a function that returns a
non-predeclared composite type.Class illustrating use of XQuery with Saxon as the
implementation, using its native "s9api".
Provides a
createTempFile function, expected to fail
if it is declared with the trusted java language.Example implementing the
ResultSetHandle interface, to return
the ResultSet from any SQL SELECT query passed as a string
to the executeSelect function.Some methods used for testing the SPI JDBC driver.
This class contains thread related methods.
Test control of access to 1-thread backend by n-thread JVM.
Example creating a couple of tables, and a function to be called when
triggered by insertion into either table.
This class contains some triggers that I found written in C under the
contrib/spi directory of the postgres source distribution.
Illustrates various methods of returning composite values.
A class to simplify testing of PL/Java's mappings between PostgreSQL and
Java/JDBC types.
A special user-defined type simply to exercise the I/O routines.
Test that strings containing characters from all Unicode planes
are passed between PG and Java without alteration (issue 21).
Uses the
ResultSetHandle interface to implement two functions,
listNonSupers and listSupers,
returning the corresponding subsets of rows from pg_user.An example that retrieves a
Properties resource, and returns
(key,value) rows from it by implementing the ResultSetProvider
interface.Illustrates use of the
ResultSetProvider interface to return
(key,value) rows from the example.properties file, also making use
of PL/Java's ObjectPool facility.This implementation uses another function that returns a set of a complex
type and returns the ResultSet produced by a query.
This implementation uses another function that returns a set of a complex
type, concatenates the name and value of that type and returns this as
a set of a scalar type.
This implementation uses another function that returns a set of a complex
type, concatenates the name and value of that type and returns this as a set
of a scalar type.
Provides example methods to illustrate variadic functions.
A User Defined Type with varlena storage, testing github issue 52.
Class illustrating use of
SQLXML to operate on non-XML data types
for which PL/Java provides an XML rendering.