A B C D E F G H I J L M N O P R S T U V W X 
All Classes All Packages

A

accumulateXY(double[], double, double) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
A common accumulator for two-variable statistical aggregates that depend on n, Sx, Sxx, Sy, Syy, and Sxy.
activate() - Method in class org.postgresql.pljava.example.UsingProperties
 
add(ComplexScalar, double) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
Add a ComplexScalar and a real (supplied as a double).
add(ComplexScalar, ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
Add two instances of ComplexScalar.
addNumbers(short, int, long, BigDecimal, BigDecimal, float, double) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
addOne(int) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
addOne(Integer) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
addOneLong(long) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
afterUsernameInsert(TriggerData) - Static method in class org.postgresql.pljava.example.Triggers
 
afterUsernameUpdate(TriggerData) - Static method in class org.postgresql.pljava.example.Triggers
 
Aggregates - Class in org.postgresql.pljava.example.annotation
A class demonstrating several aggregate functions.
allowFragment(DOMResult) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Configure a DOMResult to accept CONTENT (a/k/a document fragment), not only the more restrictive DOCUMENT.
AnyTest - Class in org.postgresql.pljava.example.annotation
Provides example methods to illustrate the polymorphic types any, anyarray, and anyelement.
AnyTest() - Constructor for class org.postgresql.pljava.example.annotation.AnyTest
 
applyAdjustments(ResultSet, T) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Apply adjustments (supplied as a row type with a named column for each desired adjustment and its value) to an instance of Adjusting.XML.Parsing.
assertHasValues(ComplexScalar, double, double) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
Assert a 'complex' has given re and im values, to test that its representation in Java corresponds to what PostgreSQL sees.
assertHasValues(ComplexTuple, double, double) - Static method in class org.postgresql.pljava.example.annotation.ComplexTuple
Assert a 'complextuple' has given re and im values, to test that its representation in Java corresponds to what PostgreSQL sees.
assertHasValues(Point, double, double) - Static method in class org.postgresql.pljava.example.annotation.Point
Assert a 'point' has given x and y values, to test that its representation in Java corresponds to what PostgreSQL sees.
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.annotation.RecordParameterDefaults
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.BinaryColumnTest
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.HugeResultSet
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.MetaDataBooleans
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.MetaDataInts
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.MetaDataStrings
 
assignRowValues(ResultSet, int) - Method in class org.postgresql.pljava.example.TupleReturn
 
assignRowValues(ResultSet, long) - Method in class org.postgresql.pljava.example.annotation.ReturnComposite
 
assignRowValues(ResultSet, long) - Method in class org.postgresql.pljava.example.annotation.UsingProperties
 
assignRowValues(ResultSet, long) - Method in class org.postgresql.pljava.example.saxon.S9
Produce and return one row of the XMLTABLE result table per call.
assignRowValues(ResultSet, long) - Method in class org.postgresql.pljava.example.UsingProperties
 

B

BinaryColumnTest - Class in org.postgresql.pljava.example
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.
BinaryColumnTest() - Constructor for class org.postgresql.pljava.example.BinaryColumnTest
 
boolOneOut(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
Has a boolean result described by one out parameter.
bounceXMLParameter(SQLXML) - Static method in class org.postgresql.pljava.example.annotation.PassXML
"Echo" an XML parameter not by creating a new writable SQLXML object at all, but simply returning the passed-in readable one untouched.
bounceXMLParameter_(SQLXML) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Just like PassXML.bounceXMLParameter(java.sql.SQLXML) but with parameter and return typed as text, and so usable on a PostgreSQL instance lacking the XML type.

C

callMetaDataMethod(String) - Static method in class org.postgresql.pljava.example.MetaDataTest
 
castTextXML(SQLXML) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Just like PassXML.bounceXMLParameter(java.sql.SQLXML) but with the parameter typed as text and the return type left as XML, so functions as a cast.
close() - Method in class org.postgresql.pljava.example.annotation.Holdability
 
close() - Method in class org.postgresql.pljava.example.annotation.RecordParameterDefaults
 
close() - Method in class org.postgresql.pljava.example.annotation.ReturnComposite
 
close() - Method in class org.postgresql.pljava.example.annotation.SetOfRecordTest
 
close() - Method in class org.postgresql.pljava.example.annotation.UsingProperties
 
close() - Method in class org.postgresql.pljava.example.BinaryColumnTest
 
close() - Method in class org.postgresql.pljava.example.HugeResultSet
 
close() - Method in class org.postgresql.pljava.example.MetaDataBooleans
 
close() - Method in class org.postgresql.pljava.example.MetaDataInts
 
close() - Method in class org.postgresql.pljava.example.MetaDataStrings
 
close() - Method in class org.postgresql.pljava.example.MetaDataTest
 
close() - Method in class org.postgresql.pljava.example.ResultSetTest
 
close() - Method in class org.postgresql.pljava.example.saxon.S9
Called when PostgreSQL has no need for more rows of the tabular result.
close() - Method in class org.postgresql.pljava.example.TupleReturn
 
close() - Method in class org.postgresql.pljava.example.Users
 
close() - Method in class org.postgresql.pljava.example.UsingProperties
 
close() - Method in class org.postgresql.pljava.example.UsingPropertiesAsResultSet
 
cmpMagnitude(ComplexScalar, ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
An integer-returning comparison function by complex magnitude, usable to complete an example btree operator class.
complexParam(ResultSet[]) - Static method in class org.postgresql.pljava.example.annotation.PGF1010962
Test for bug 1010962: pass in an array of A1010962, expect no TupleDesc reference leak warnings.
ComplexScalar - Class in org.postgresql.pljava.example.annotation
Complex (re and im parts are doubles) implemented in Java as a scalar UDT.
ComplexScalar() - Constructor for class org.postgresql.pljava.example.annotation.ComplexScalar
 
ComplexScalar(double, double, String) - Constructor for class org.postgresql.pljava.example.annotation.ComplexScalar
 
ComplexTuple - Class in org.postgresql.pljava.example.annotation
Complex (re and im parts are doubles) implemented in Java as a mapped UDT.
ComplexTuple() - Constructor for class org.postgresql.pljava.example.annotation.ComplexTuple
 
componentsEQ(ComplexScalar, ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
True if the left argument and the right are componentwise equal.
ConditionalDDR - Class in org.postgresql.pljava.example.annotation
Test of a very simple form of conditional execution in the deployment descriptor using only the <implementor name> specified for an <implementor block>.
ConditionalDDR() - Constructor for class org.postgresql.pljava.example.annotation.ConditionalDDR
 
count(double[]) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
Finisher that returns the count of non-null rows accumulated.
countNulls(Integer[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
countNulls(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
createIterator(int) - Static method in class org.postgresql.pljava.example.RandomInts
 
createTempFile() - Static method in class org.postgresql.pljava.example.Security
The following method should fail if the language in use is trusted.

D

disallow44(TriggerData) - Static method in class org.postgresql.pljava.example.annotation.Triggers
Throw exception if value to be inserted is 44.

E

echoXMLParameter(SQLXML, int, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Echo an XML parameter back, exercising seven different ways (howin => 1-7) of reading an SQLXML object, and seven (howout => 1-7) of returning one.
echoXMLParameter_(SQLXML, int, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Echo an XML parameter back, but with parameter and return types of PostgreSQL text.
ensureClosed(Result, SQLXML, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Ensure the closing of whatever method was used to add content to an SQLXML object.
Enumeration - Class in org.postgresql.pljava.example.annotation
Confirms the mapping of PG enum and Java String, and arrays of each, as parameter and return types.
Enumeration() - Constructor for class org.postgresql.pljava.example.annotation.Enumeration
 
eqToReal(ComplexScalar, double) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
True if the complex argument is real-valued and equal to the real argument.
examineRows(TriggerData) - Static method in class org.postgresql.pljava.example.annotation.Triggers
Examine old and new rows in reponse to a trigger.
executeSelect(int) - Static method in class org.postgresql.pljava.example.HugeResultSet
 
executeSelect(String) - Static method in class org.postgresql.pljava.example.annotation.SetOfRecordTest
 
executeSelect(String) - Static method in class org.postgresql.pljava.example.ResultSetTest
 

F

finishAvgX(double[]) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
Finisher that returns the mean of the accumulated x values.
finishAvgY(double[]) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
Finisher that returns the mean of the accumulated y values.
finishIntercept(double[]) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
Finisher that returns the intercept of a regression line.
finishRegr(double[], ResultSet) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
A finisher that returns the slope and intercept together.
finishSlope(double[]) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
Finisher that returns the slope of a regression line.
forceDeadlock() - Static method in class org.postgresql.pljava.example.Threads
 
free() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
free() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 

G

getBinaryPairs() - Static method in class org.postgresql.pljava.example.BinaryColumnTest
 
getBinaryStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
getBinaryStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
getCharacterStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
getCharacterStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
getDatabaseMetaDataBooleans() - Static method in class org.postgresql.pljava.example.MetaDataBooleans
 
getDatabaseMetaDataInts() - Static method in class org.postgresql.pljava.example.MetaDataInts
 
getDatabaseMetaDataStrings() - Static method in class org.postgresql.pljava.example.MetaDataStrings
 
getDate() - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
getDateAsString() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
getProperties() - Static method in class org.postgresql.pljava.example.annotation.UsingPropertiesAsScalarSet
 
getProperties() - Static method in class org.postgresql.pljava.example.UsingProperties
 
getProperties() - Static method in class org.postgresql.pljava.example.UsingPropertiesAsResultSet
 
getProperties() - Static method in class org.postgresql.pljava.example.UsingPropertiesAsScalarSet
 
getResultSet() - Method in class org.postgresql.pljava.example.annotation.Holdability
 
getResultSet() - Method in class org.postgresql.pljava.example.annotation.SetOfRecordTest
 
getResultSet() - Method in class org.postgresql.pljava.example.Users
 
getResultSet() - Method in class org.postgresql.pljava.example.UsingPropertiesAsResultSet
 
getSource(Class<T>) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
getSource(Class<T>) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.ComplexScalar
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.ComplexTuple
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.IntWithMod
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.PassXML
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.Point
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
getSQLTypeName() - Method in class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 
getString() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
getString() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
getTime() - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
getTimeAsString() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
getTimestamp() - Static method in class org.postgresql.pljava.example.annotation.Parameters
 

H

hasNext() - Method in class org.postgresql.pljava.example.RandomInts
 
helloOneOut() - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
Returns a result described by one out parameter.
helloOneOutTable() - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
Returns a table result described by one out parameter.
helloOutParams(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
Returns a two-column composite result that does not have to be a predeclared composite type, or require the calling SQL query to follow the function call with a result column definition list, as is needed for a bare RECORD return type.
helloTable() - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
Returns a two-column table result that does not have to be a predeclared composite type, or require the calling SQL query to follow the function call with a result column definition list, as is needed for a bare RECORD return type.
Holdability - Class in org.postgresql.pljava.example.annotation
Demonstrate holdability of ResultSets (test for issue 168).
HugeResultSet - Class in org.postgresql.pljava.example
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.
HugeResultSet(int) - Constructor for class org.postgresql.pljava.example.HugeResultSet
 

I

insertUsername(TriggerData) - Static method in class org.postgresql.pljava.example.annotation.Triggers
insert user name in response to a trigger.
insertUsername(TriggerData) - Static method in class org.postgresql.pljava.example.Triggers
insert user name in response to a trigger.
inStringoutXML(String) - Static method in class org.postgresql.pljava.example.annotation.PassXML
 
IntWithMod - Class in org.postgresql.pljava.example.annotation
An integer-like data type accepting a type modifier: IntWithMod(even) or IntWithMod(odd).
IntWithMod() - Constructor for class org.postgresql.pljava.example.annotation.IntWithMod
 
inXMLoutString(SQLXML) - Static method in class org.postgresql.pljava.example.annotation.PassXML
 
issue199() - Static method in class org.postgresql.pljava.example.annotation.PreJSR310
Test for a regression in PG date to/from java.sql.Date conversion identified in issue #199.
issue228() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
Confirm JDBC behavior of Savepoint, in particular that a Savepoint rolled back to still exists and can be rolled back to again or released.

J

javaSpecificationGE(String) - Static method in class org.postgresql.pljava.example.annotation.JDBC42_21
Return true if running under a Java specification version at least as recent as the argument ('1.6', '1.7', '1.8', '9', '10', '11', ...).
JDBC42_21 - Class in org.postgresql.pljava.example.annotation
Exercise new mappings between date/time types and java.time classes (JDBC 4.2 change 21).
JDBC42_21() - Constructor for class org.postgresql.pljava.example.annotation.JDBC42_21
 

L

leakStatements(TriggerData) - Static method in class org.postgresql.pljava.example.Triggers
 
like_regex(String, String, String, boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
Function form of the ISO SQL <regex like predicate>.
listNonSupers() - Static method in class org.postgresql.pljava.example.Users
 
listSupers() - Static method in class org.postgresql.pljava.example.Users
 
logAndReturn(ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
Return the same 'complex' passed in, logging its contents at level INFO.
logAndReturn(ComplexTuple) - Static method in class org.postgresql.pljava.example.annotation.ComplexTuple
Return the same 'complextuple' passed in, logging its contents at level INFO.
logAndReturn(Point) - Static method in class org.postgresql.pljava.example.annotation.Point
Return the same 'point' passed in, logging its contents at level INFO.
logAny(Object) - Static method in class org.postgresql.pljava.example.annotation.AnyTest
Log (at INFO level) the Java class received for the passed argument.
logAnyElement(Object) - Static method in class org.postgresql.pljava.example.annotation.AnyTest
Log (at INFO level) the Java class received for the passed argument, and return the same value.
LoggerTest - Class in org.postgresql.pljava.example
Provides a function to log, at the specified level, a specified message.
LoggerTest() - Constructor for class org.postgresql.pljava.example.LoggerTest
 
logMessage(String, String) - Static method in class org.postgresql.pljava.example.LoggerTest
 
lowLevelXMLEcho(String) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Low-level XML echo where the Java parameter and return type are String.
lowLevelXMLEcho(SQLXML, int, ResultSet) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Echo the XML parameter back, using lower-level manipulations than echoXMLParameter.
lowLevelXMLEcho_(SQLXML, int, ResultSet) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Text-typed variant of lowLevelXMLEcho (does not require XML type).

M

magnitudeLT(ComplexScalar, ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
True if the left argument is smaller than the right in magnitude (Euclidean distance from the origin).
makeArray(Object) - Static method in class org.postgresql.pljava.example.annotation.AnyTest
Return the Java object received for the passed argument, wrapped in a one-element array with the object's class as its element type.
makeString(ResultSet) - Static method in class org.postgresql.pljava.example.TupleReturn
 
maxFromSetReturnExample(int, int) - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
MetaDataBooleans - Class in org.postgresql.pljava.example
Example returning (varchar,boolean) rows, one for each boolean-valued attribute in the JDBC DatabaseMetaData.
MetaDataBooleans() - Constructor for class org.postgresql.pljava.example.MetaDataBooleans
 
MetaDataInts - Class in org.postgresql.pljava.example
Example returning (varchar,int) rows, one for each int-valued attribute in the JDBC DatabaseMetaData.
MetaDataInts() - Constructor for class org.postgresql.pljava.example.MetaDataInts
 
MetaDataStrings - Class in org.postgresql.pljava.example
Example returning (varchar,varchar) rows, one for each String-valued attribute in the JDBC DatabaseMetaData.
MetaDataStrings() - Constructor for class org.postgresql.pljava.example.MetaDataStrings
 
MetaDataTest - Class in org.postgresql.pljava.example
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.
MetaDataTest(String) - Constructor for class org.postgresql.pljava.example.MetaDataTest
 
minMagnitude(ComplexScalar, ComplexScalar) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
As an ordinary function, returns the lesser in magnitude of two arguments; as a simple aggregate, returns the least in magnitude over its aggregated arguments.
mockedXMLEcho(byte[]) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Supply a sequence of bytes to be the exact (encoded) content of an XML value, which will be returned; if the encoding is not UTF-8, the value should begin with an XML Decl that names the encoding.
mockedXMLEcho(String) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Supply a sequence of characters to be the exact (Unicode) content of an XML value, which will be returned; if the value begins with an XML Decl that names an encoding, the content will be assumed to contain only characters representable in that encoding.
modApply(IntWithMod, int, boolean) - Static method in class org.postgresql.pljava.example.annotation.IntWithMod
Function backing the type-modifier application cast for IntWithMod type.
moddatetime(TriggerData) - Static method in class org.postgresql.pljava.example.Triggers
Update a modification time when the row is updated.
modIn(String[]) - Static method in class org.postgresql.pljava.example.annotation.IntWithMod
Type modifier input function for IntWithMod type: accepts "even" or "odd".
modOut(int) - Static method in class org.postgresql.pljava.example.annotation.IntWithMod
Type modifier output function for IntWithMod type.
moodsToTexts(String[]) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
 
moodToText(String) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
 

N

nestedStatements(int) - Static method in class org.postgresql.pljava.example.annotation.SPIActions
Test of bug #1556
next() - Method in class org.postgresql.pljava.example.RandomInts
 
notOutParams(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.ReturnComposite
A function that does not return a composite type, despite having a similar Java form.
nullOnEven(int) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 

O

occurrences_regex(String, String, String, int, boolean, boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
Syntax-sugar-free form of the ISO SQL OCCURRENCES_REGEX function: how many times does a pattern occur in a string?
org.postgresql.pljava.example - package org.postgresql.pljava.example
The examples that have been around the longest, and are deployed using hand-written SQL deployment code (see src/main/resources/deployment), not having been reworked to use annotations yet.
org.postgresql.pljava.example.annotation - package org.postgresql.pljava.example.annotation
The first examples that were converted to test the annotation-driven SQL generator instead of using hand-written SQL deployment code.
org.postgresql.pljava.example.saxon - package org.postgresql.pljava.example.saxon
Examples using the Saxon-HE library for XML processing.

P

paramDefaultsNamedRow(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.RecordParameterDefaults
Like paramDefaultsRecord but illustrating the use of a named row type with known structure, and supplying a default for the function parameter.
paramDefaultsRecord(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.RecordParameterDefaults
Return the names, types, and values of parameters supplied as a single anonymous RECORD type; the parameter is given an empty-record default, allowing it to be omitted in calls, or used with the named-parameter call syntax.
Parameters - Class in org.postgresql.pljava.example.annotation
Some methods used for testing parameter and return value coersion and resolution of overloaded methods.
Parameters() - Constructor for class org.postgresql.pljava.example.annotation.Parameters
 
parse(String, String) - Static method in class org.postgresql.pljava.example.annotation.ComplexScalar
 
parse(String, String) - Static method in class org.postgresql.pljava.example.annotation.IntWithMod
 
parse(String, String) - Static method in class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
parse(String, String) - Static method in class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 
passivate() - Method in class org.postgresql.pljava.example.UsingProperties
 
PassXML - Class in org.postgresql.pljava.example.annotation
Class illustrating use of SQLXML to operate on XML data.
PassXML() - Constructor for class org.postgresql.pljava.example.annotation.PassXML
No-arg constructor required of objects that will implement SQLData.
PassXML.SQLXMLMock - Class in org.postgresql.pljava.example.annotation
Class that will mock an SQLXML instance, returning only binary or character stream data from a byte array or string supplied at construction.
PassXML.SQLXMLProxy - Class in org.postgresql.pljava.example.annotation
Class that will proxy methods to another SQLXML class.
PGF1010962 - Class in org.postgresql.pljava.example.annotation
A gnarly test of TupleDesc reference management, crafted by Johann Oskarsson for bug report 1010962 on pgFoundry.
PGF1010962() - Constructor for class org.postgresql.pljava.example.annotation.PGF1010962
 
pgNodeTreeAsXML(SQLXML) - Static method in class org.postgresql.pljava.example.annotation.XMLRenderedTypes
 
Point - Class in org.postgresql.pljava.example.annotation
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.
Point() - Constructor for class org.postgresql.pljava.example.annotation.Point
 
position_regex(String, String, String, int, boolean, boolean, int, int, boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
Syntax-sugar-free form of the ISO SQL POSITION_REGEX function: where does a pattern, or part of it, occur in a string?
PreJSR310 - Class in org.postgresql.pljava.example.annotation
Some tests of pre-JSR 310 date/time/timestamp conversions.
PreJSR310() - Constructor for class org.postgresql.pljava.example.annotation.PreJSR310
 
prepareXMLSchema(String, SQLXML, String, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Precompile a schema source in schema language lang and save it (for the current session) as name.
prepareXMLTransform(String, SQLXML, int, boolean, boolean, ResultSet) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Precompile an XSL transform source and save it (for the current session) as name.
prepareXMLTransformWithJava(String, SQLXML, int, boolean, boolean, ResultSet) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Precompile an XSL transform source and save it (for the current session) as name, where the transform may call Java methods.
print(byte) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(byte[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(double) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(double[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(float) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(float[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(int) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(int[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(long) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(long[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(short) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(short[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(Integer[]) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(Date) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(Time) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
print(Timestamp) - Static method in class org.postgresql.pljava.example.annotation.Parameters
 
propertyExampleAnno() - Static method in class org.postgresql.pljava.example.annotation.UsingProperties
Return the contents of the example.properties resource, one (key,value) row per entry.
propertyExampleRB() - Static method in class org.postgresql.pljava.example.annotation.UsingProperties
Return the contents of the example.properties resource, one (key,value) row per entry, using ResourceBundle to load it.
proxiedXMLEcho(SQLXML, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Proxy a PL/Java SQLXML source object as if it were of a non-PL/Java implementing class, to confirm that it can still be returned successfully to PostgreSQL.

R

RandomInts - Class in org.postgresql.pljava.example
Provides a function producing as many rows as requested, each with a random int.
RandomInts(int) - Constructor for class org.postgresql.pljava.example.RandomInts
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.ComplexScalar
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.ComplexTuple
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.IntWithMod
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.PassXML
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.Point
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
readSQL(SQLInput, String) - Method in class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 
RecordParameterDefaults - Class in org.postgresql.pljava.example.annotation
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.
registerTransactionListener() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
remove() - Method in class org.postgresql.pljava.example.RandomInts
 
remove() - Method in class org.postgresql.pljava.example.UsingProperties
 
removeXY(double[], double, double) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
'Removes' from the state a row previously accumulated, for possible use in a window with a moving frame start.
ResultSetTest - Class in org.postgresql.pljava.example
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.
ResultSetTest(String) - Constructor for class org.postgresql.pljava.example.ResultSetTest
 
ReturnComposite - Class in org.postgresql.pljava.example.annotation
Demonstrates @Function(out={...}) for a function that returns a non-predeclared composite type.
ReturnComposite() - Constructor for class org.postgresql.pljava.example.annotation.ReturnComposite
 
roundTrip(ResultSet, String, boolean, ResultSet) - Static method in class org.postgresql.pljava.example.annotation.TypeRoundTripper
Function accepting one parameter of row type (one column, any type) and returning a row with up to six columns (use a column definition list after the function call, choose column names from TYPEPG, TYPEJDBC, CLASSJDBC, CLASS, TOSTRING, ROUNDTRIPPED where any of the first five must have text/varchar type, while ROUNDTRIPPED must match the type of the input column).
run() - Method in class org.postgresql.pljava.example.annotation.ThreadTest
 

S

S9 - Class in org.postgresql.pljava.example.saxon
Class illustrating use of XQuery with Saxon as the implementation, using its native "s9api".
Security - Class in org.postgresql.pljava.example
Provides a createTempFile function, expected to fail if it is declared with the trusted java language.
Security() - Constructor for class org.postgresql.pljava.example.Security
 
setBinaryStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
setBinaryStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
setCharacterStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
setCharacterStream() - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
SetOfRecordTest - Class in org.postgresql.pljava.example.annotation
Example implementing the ResultSetHandle interface, to return the ResultSet from any SQL SELECT query passed as a string to the executeSelect function.
SetOfRecordTest(String) - Constructor for class org.postgresql.pljava.example.annotation.SetOfRecordTest
 
setParameter() - Static method in class org.postgresql.pljava.example.annotation.ComplexTuple
Pass a 'complextuple' UDT as a parameter to a PreparedStatement that returns it, and verify that it makes the trip intact.
setResult(Class<T>) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
setResult(Class<T>) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
setReturn(int, int) - Static method in class org.postgresql.pljava.example.TupleReturn
 
setString(String) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
setString(String) - Method in class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
SPIActions - Class in org.postgresql.pljava.example.annotation
Some methods used for testing the SPI JDBC driver.
SPIActions() - Constructor for class org.postgresql.pljava.example.annotation.SPIActions
 
SQLXMLMock(byte[]) - Constructor for class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
SQLXMLMock(String) - Constructor for class org.postgresql.pljava.example.annotation.PassXML.SQLXMLMock
 
SQLXMLProxy(SQLXML, int) - Constructor for class org.postgresql.pljava.example.annotation.PassXML.SQLXMLProxy
 
stashResultSet() - Static method in class org.postgresql.pljava.example.annotation.Holdability
Query all rows from pg_description, but stash the ResultSet for retrieval later in the same transaction by unstashResultSet.
strictlyNestedTest() - Static method in class org.postgresql.pljava.example.annotation.ThreadTest
Test that another thread can enter SPI while the calling thread is out.
substring_regex(String, String, String, int, boolean, int, int, boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
Syntax-sugar-free form of the ISO SQL SUBSTRING_REGEX function: return a substring specified by a pattern match in a string.
sum(double, double) - Static method in class org.postgresql.pljava.example.annotation.Aggregates
An example aggregate that sums its input.
sumOfSquares(double[]) - Static method in class org.postgresql.pljava.example.annotation.Variadic
Compute a double-precision sum of squares, treating any null input as zero.
sumOfSquaresBoxed(Double[]) - Static method in class org.postgresql.pljava.example.annotation.Variadic
Compute a double-precision sum of squares, returning null if any input value is null.

T

testSavepointSanity() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
testTransactionRecovery() - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
textsToMoods(String[]) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
 
textToMood(String) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
 
Threads - Class in org.postgresql.pljava.example
This class contains thread related methods.
Threads() - Constructor for class org.postgresql.pljava.example.Threads
 
ThreadTest - Class in org.postgresql.pljava.example.annotation
Test control of access to 1-thread backend by n-thread JVM.
ThreadTest() - Constructor for class org.postgresql.pljava.example.annotation.ThreadTest
 
toString() - Method in class org.postgresql.pljava.example.annotation.ComplexScalar
 
toString() - Method in class org.postgresql.pljava.example.annotation.IntWithMod
 
toString() - Method in class org.postgresql.pljava.example.annotation.Point
 
toString() - Method in class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
toString() - Method in class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 
transferPeopleWithSalary(int) - Static method in class org.postgresql.pljava.example.annotation.SPIActions
 
transformXML(String, SQLXML, int, int, ResultSet, Boolean, Integer) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Transform some XML according to a named transform prepared with prepareXMLTransform.
translate_regex(String, String, String, String, int, boolean, int, boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
Syntax-sugar-free form of the ISO SQL TRANSLATE_REGEX function: return a string constructed from the input string by replacing one specified occurrence, or all occurrences, of a matching pattern.
Triggers - Class in org.postgresql.pljava.example.annotation
Example creating a couple of tables, and a function to be called when triggered by insertion into either table.
Triggers - Class in org.postgresql.pljava.example
This class contains some triggers that I found written in C under the contrib/spi directory of the postgres source distribution.
Triggers() - Constructor for class org.postgresql.pljava.example.annotation.Triggers
 
Triggers() - Constructor for class org.postgresql.pljava.example.Triggers
 
tupleReturn(int, int, ResultSet) - Static method in class org.postgresql.pljava.example.TupleReturn
 
tupleReturn(Integer, Integer, ResultSet) - Static method in class org.postgresql.pljava.example.TupleReturn
 
TupleReturn - Class in org.postgresql.pljava.example
Illustrates various methods of returning composite values.
TupleReturn(int, int) - Constructor for class org.postgresql.pljava.example.TupleReturn
 
TypeRoundTripper - Class in org.postgresql.pljava.example.annotation
A class to simplify testing of PL/Java's mappings between PostgreSQL and Java/JDBC types.

U

UDTScalarIOTest - Class in org.postgresql.pljava.example.annotation
A special user-defined type simply to exercise the I/O routines.
UDTScalarIOTest() - Constructor for class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
unclosedSQLXML(int, int) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Create and leave some number of SQLXML objects unclosed, unused, and unreferenced, as a test of reclamation.
UnicodeRoundTripTest - Class in org.postgresql.pljava.example.annotation
Test that strings containing characters from all Unicode planes are passed between PG and Java without alteration (issue 21).
UnicodeRoundTripTest() - Constructor for class org.postgresql.pljava.example.annotation.UnicodeRoundTripTest
 
unicodetest(String, int[], ResultSet) - Static method in class org.postgresql.pljava.example.annotation.UnicodeRoundTripTest
This function takes a string and an array of ints constructed in PG, such that PG believes the codepoints in the string to correspond exactly with the ints in the array.
unstashResultSet() - Static method in class org.postgresql.pljava.example.annotation.Holdability
Return the results stashed earlier in the same transaction by stashResultSet.
Users - Class in org.postgresql.pljava.example
Uses the ResultSetHandle interface to implement two functions, listNonSupers and listSupers, returning the corresponding subsets of rows from pg_user.
Users(String) - Constructor for class org.postgresql.pljava.example.Users
 
UsingProperties - Class in org.postgresql.pljava.example.annotation
An example that retrieves a Properties resource, and returns (key,value) rows from it by implementing the ResultSetProvider interface.
UsingProperties - Class in org.postgresql.pljava.example
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.
UsingProperties() - Constructor for class org.postgresql.pljava.example.annotation.UsingProperties
 
UsingProperties(ObjectPool<UsingProperties>) - Constructor for class org.postgresql.pljava.example.UsingProperties
 
UsingPropertiesAsResultSet - Class in org.postgresql.pljava.example
This implementation uses another function that returns a set of a complex type and returns the ResultSet produced by a query.
UsingPropertiesAsResultSet() - Constructor for class org.postgresql.pljava.example.UsingPropertiesAsResultSet
 
UsingPropertiesAsScalarSet - Class in org.postgresql.pljava.example.annotation
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.
UsingPropertiesAsScalarSet - Class in org.postgresql.pljava.example
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.
UsingPropertiesAsScalarSet() - Constructor for class org.postgresql.pljava.example.annotation.UsingPropertiesAsScalarSet
 
UsingPropertiesAsScalarSet() - Constructor for class org.postgresql.pljava.example.UsingPropertiesAsScalarSet
 

V

Variadic - Class in org.postgresql.pljava.example.annotation
Provides example methods to illustrate variadic functions.
VarlenaUDTTest - Class in org.postgresql.pljava.example.annotation
A User Defined Type with varlena storage, testing github issue 52.
VarlenaUDTTest() - Constructor for class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 

W

writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.ComplexScalar
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.ComplexTuple
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.IntWithMod
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.PassXML
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.Point
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.UDTScalarIOTest
 
writeSQL(SQLOutput) - Method in class org.postgresql.pljava.example.annotation.VarlenaUDTTest
 

X

xmlcast(ResultSet, Boolean, ResultSet) - Static method in class org.postgresql.pljava.example.saxon.S9
An implementation of XMLCAST.
xmlexists(String, ResultSet, String[]) - Static method in class org.postgresql.pljava.example.saxon.S9
An implementation of XMLEXISTS(expression PASSING BY VALUE passing), using genuine XQuery.
xmlFromComposite() - Static method in class org.postgresql.pljava.example.annotation.PassXML
Test the MappedUDT (in one direction anyway).
xmlInStmtAndRS(ResultSet) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Create some XML, pass it to a SELECT ? prepared statement, retrieve it from the result set, and return it via the out-parameter result set of this RECORD-returning function.
XMLRenderedTypes - Class in org.postgresql.pljava.example.annotation
Class illustrating use of SQLXML to operate on non-XML data types for which PL/Java provides an XML rendering.
XMLRenderedTypes() - Constructor for class org.postgresql.pljava.example.annotation.XMLRenderedTypes
 
xmltable(String, String[], ResultSet, String[], Boolean) - Static method in class org.postgresql.pljava.example.saxon.S9
An implementation of (much of) XMLTABLE, using genuine XML Query.
xmltext(String) - Static method in class org.postgresql.pljava.example.saxon.S9
PostgreSQL (as of 12) lacks the XMLTEXT function, so here it is.
xmlTextNode(byte[], String, int, boolean) - Static method in class org.postgresql.pljava.example.annotation.PassXML
Test serialization into the PostgreSQL server encoding by returning a text node, optionally wrapped in an element, containing the supplied stuff.
xq_ret_content(String, Boolean, ResultSet, String[]) - Static method in class org.postgresql.pljava.example.saxon.S9
A simple example corresponding to XMLQUERY(expression PASSING BY VALUE passing RETURNING CONTENT {NULL|EMPTY} ON EMPTY).
A B C D E F G H I J L M N O P R S T U V W X 
All Classes All Packages