Package org.postgresql.pljava.example.annotation

Class PGF1010962

java.lang.Object

org.postgresql.pljava.example.annotation.PGF1010962

@SQLAction(requires="1010962 func",
           install={"CREATE TYPE javatest.B1010962 AS ( b1_val float8, b2_val int)","CREATE TYPE javatest.C1010962 AS ( c1_val float8, c2_val float8)","CREATE TYPE javatest.A1010962 as ( b B1010962, c C1010962, a_val int)","SELECT javatest.complexParam(array_agg( CAST(  (   CAST((0.1, i)    AS javatest.B1010962),   CAST((0.1, 10/i) AS javatest.C1010962),   i  ) AS javatest.A1010962) )) FROM generate_series (1,10) i"},
           remove={"DROP TYPE javatest.A1010962","DROP TYPE javatest.C1010962","DROP TYPE javatest.B1010962"})
public class PGF1010962
extends Object

A gnarly test of TupleDesc reference management, crafted by Johann Oskarsson for bug report 1010962 on pgFoundry.

Constructor Summary

Constructors

Constructor	Description
PGF1010962()

Method Summary

Modifier and Type	Method	Description
static int	complexParam(ResultSet[] receiver)	Test for bug 1010962: pass in an array of A1010962, expect no TupleDesc reference leak warnings.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PGF1010962

public PGF1010962()

Method Details

complexParam

@Function(schema="javatest",
          provides="1010962 func")
public static int complexParam(ResultSet[] receiver)
                        throws SQLException

Test for bug 1010962: pass in an array of A1010962, expect no TupleDesc reference leak warnings.

Parameters:

receiver - Looks polymorphic, but expects an array of A1010962

Returns:

0

Throws:

SQLException