Index (PL/Java examples 1.6.7)

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.
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.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.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
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.
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