Index (PL/Java examples 1.6.9)

A B C D E F G H I J L M N O P R S T U V W X
All Classes and Interfaces|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.
answer() - Static method in interface org.postgresql.pljava.example.annotation.OnInterface: Returns the answer.
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.Modules
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

B() - Constructor for class org.postgresql.pljava.example.annotation.OnInterface.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

C() - Constructor for class org.postgresql.pljava.example.annotation.OnInterface.B.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.Modules
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>.
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
Extensions - Search tag in class org.postgresql.pljava.example.saxon.S9: Section

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
Functions/predicates from ISO 9075-14 SQL/XML - Search tag in class org.postgresql.pljava.example.saxon.S9: Section

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

java_modules() - Static method in class org.postgresql.pljava.example.annotation.Modules: Returns information on the named modules in Java's boot module layer.
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.
Modules - Class in org.postgresql.pljava.example.annotation: Example code to support querying for the modules in Java's boot layer.
moodsToTexts(String[]) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
moodToText(String) - Static method in class org.postgresql.pljava.example.annotation.Enumeration
moreNestedAnswer() - Static method in class org.postgresql.pljava.example.annotation.OnInterface.B.C: That answer again.

N

nestedAnswer() - Static method in interface org.postgresql.pljava.example.annotation.OnInterface.A: Again the answer.
nestedClassAnswer() - Static method in class org.postgresql.pljava.example.annotation.OnInterface.B: Still the answer.
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?
OnInterface - Interface in org.postgresql.pljava.example.annotation: Illustrates PL/Java functions on an interface instead of a class.
OnInterface.A - Interface in org.postgresql.pljava.example.annotation
OnInterface.B - Class in org.postgresql.pljava.example.annotation
OnInterface.B.C - Class in org.postgresql.pljava.example.annotation
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.
presentOnClassPath(String[]) - Static method in class org.postgresql.pljava.example.annotation.ConditionalDDR: Tests class names in the supplied order, returning false as soon as any cannot be found by the class loader(s) available to the examples jar, or true if all can be found.
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".
Saxon extension to XQuery regular expressions - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
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.
XMLCAST - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
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.
XMLEXISTS - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
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.
XMLQUERY - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
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.
XMLTABLE - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
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).
XQuery module prolog allowed - Search tag in class org.postgresql.pljava.example.saxon.S9: Section
XQuery regular-expression functions in ISO 9075-2 Foundations - Search tag in class org.postgresql.pljava.example.saxon.S9: Section

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