-- psql -d postgres -a -f implicitCasts.sql > result.log 2>&1
\pset null 'NULL'

DROP TYPE IF EXISTS structIntDoubleTy;
DROP TYPE IF EXISTS structStringIntTy;

CREATE TYPE structIntDoubleTy AS (
  d0 int,
  d1 float8
);

CREATE TYPE structStringIntTy AS (
  d0 text,
  d1 int
);

DROP TABLE IF EXISTS srcTestTable;
CREATE TABLE srcTestTable(
  shortVal smallint,
  intVal int,
  longVal bigint,
  doubleVal float8,
  floatVal float4,
  decimal3_0Val decimal(3, 0),
  decimal5_0Val decimal(5, 0),
  decimal10_0Val decimal(10, 0),
  decimal10_2Val decimal(10, 2),
  decimal20_0Val decimal(20, 0),
  decimal30_15Val decimal(30, 15),
  decimal14_7Val decimal(14, 7),
  binaryVal bytea,
  booleanVal boolean,
  stringVal text,
  dateVal date,
  timestampVal timestamp,
  arrayIntVal int[],
  arrayDoubleVal float8[],
  structIntDoubleVal structIntDoubleTy,
  structStringIntVal structStringIntTy
);

INSERT INTO srcTestTable VALUES(
  1, 1, 1, 1.0, 1.0, 1, 1, 1, 1.0, 1.0, 1.0, 1.0, 'abc', true, 'abc', '1970-01-01', '1970-01-01 00:00:00',
  '{1, 2, 3}', '{1.0, 2.0, 3.0}', ROW(1, 1.0), ROW('a', 1)
);

INSERT INTO srcTestTable VALUES(
  32767, 2147483647, 9223372036854775807, 1.797693e+308, 3.402823e+38,
  999, 99999, 9999999999, 99999.99, 9999999999999999999, 999999999999999.999999999999999, 9999999.9999999,
  'def', false, 'def', '2018-07-06', '2018-07-06 00:00:00',
  '{4, 5, 6}', '{4.0, 5.0, 6.0}', ROW(2, 2.0), ROW('b', 2)
);

SELECT * FROM srcTestTable;

-- binary arithmetic expression cases

-- (short, *)
SELECT pg_typeof(shortVal * intVal) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * longVal) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * doubleVal) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * floatVal) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal3_0Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal5_0Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal10_0Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal10_2Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal20_0Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal30_15Val) FROM srcTestTable WHERE shortVal = 1;
SELECT pg_typeof(shortVal * decimal14_7Val) FROM srcTestTable WHERE shortVal = 1;

-- (int, *)
SELECT pg_typeof(intVal * longVal) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * doubleVal) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * floatVal) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal3_0Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal5_0Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal10_0Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal10_2Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal20_0Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal30_15Val) FROM srcTestTable WHERE intVal = 1;
SELECT pg_typeof(intVal * decimal14_7Val) FROM srcTestTable WHERE intVal = 1;

-- (long, *)
SELECT pg_typeof(longVal * doubleVal) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * floatVal) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal3_0Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal5_0Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal10_0Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal10_2Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal20_0Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal30_15Val) FROM srcTestTable WHERE longVal = 1;
SELECT pg_typeof(longVal * decimal14_7Val) FROM srcTestTable WHERE longVal = 1;

-- (double, *)
SELECT pg_typeof(doubleVal * floatVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal3_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal5_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal10_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal10_2Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal20_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal30_15Val) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT pg_typeof(doubleVal * decimal14_7Val) FROM srcTestTable WHERE doubleVal < 1.1;

-- (float, *)
SELECT pg_typeof(floatVal * decimal3_0Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal5_0Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal10_0Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal10_2Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal20_0Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal30_15Val) FROM srcTestTable WHERE floatVal < 1.1;
SELECT pg_typeof(floatVal * decimal14_7Val) FROM srcTestTable WHERE floatVal < 1.1;

-- (decimal(3, 0), *)
SELECT pg_typeof(decimal3_0Val * decimal5_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT pg_typeof(decimal3_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT pg_typeof(decimal3_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT pg_typeof(decimal3_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT pg_typeof(decimal3_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT pg_typeof(decimal3_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal3_0Val = 1;

-- (decimal(5, 0), *)
SELECT pg_typeof(decimal5_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT pg_typeof(decimal5_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT pg_typeof(decimal5_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT pg_typeof(decimal5_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT pg_typeof(decimal5_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal5_0Val = 1;

-- (decimal(10, 0), *)
SELECT pg_typeof(decimal10_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT pg_typeof(decimal10_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT pg_typeof(decimal10_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT pg_typeof(decimal10_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_0Val = 1;

-- (decimal(10, 2), *)
SELECT pg_typeof(decimal10_2Val * decimal20_0Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT pg_typeof(decimal10_2Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT pg_typeof(decimal10_2Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_2Val = 1;

-- (decimal(30, 15), *)
SELECT pg_typeof(decimal30_15Val * decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT pg_typeof(decimal30_15Val * decimal14_7Val) FROM srcTestTable WHERE decimal30_15Val = 1;


-- binary arithmetic expression cases

-- (binary, *)
SELECT pg_typeof(binaryVal || shortVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || intVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || longVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || doubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || floatVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || booleanVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || stringVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || dateVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || timestampVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(binaryVal || structStringIntVal) FROM srcTestTable LIMIT 1;

-- (text, *)
SELECT pg_typeof(stringVal || shortVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || intVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || longVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || doubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || floatVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || booleanVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || stringVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || dateVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || timestampVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT pg_typeof(stringVal || structStringIntVal) FROM srcTestTable LIMIT 1;


-- function inputs

-- from * to short
DROP FUNCTION IF EXISTS shortIn;
CREATE FUNCTION shortIn(smallint) RETURNS smallint
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT shortIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT shortIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT shortIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT shortIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
SELECT shortIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT shortIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT shortIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT shortIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT shortIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT shortIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT shortIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT shortIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT shortIn(null);

-- from * to int
DROP FUNCTION IF EXISTS intIn;
CREATE FUNCTION intIn(int) RETURNS int
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT intIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT intIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT intIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT intIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
SELECT intIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT intIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT intIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT intIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT intIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT intIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT intIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT intIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT intIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT intIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT intIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT intIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT intIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT intIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT intIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT intIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT intIn(null);

-- from * to long
DROP FUNCTION IF EXISTS longIn;
CREATE FUNCTION longIn(bigint) RETURNS bigint
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT longIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT longIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT longIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT longIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
SELECT longIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT longIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT longIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT longIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT longIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT longIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT longIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT longIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT longIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT longIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT longIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT longIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT longIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT longIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT longIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT longIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT longIn(null);

-- from * to float8
DROP FUNCTION IF EXISTS doubleIn;
CREATE FUNCTION doubleIn(float8) RETURNS float8
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT doubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT doubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT doubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT doubleIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
SELECT doubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT doubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT doubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT doubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT doubleIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT doubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT doubleIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT doubleIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT doubleIn(null);

-- from * to float4
DROP FUNCTION IF EXISTS floatIn;
CREATE FUNCTION floatIn(float4) RETURNS float4
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT floatIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT floatIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT floatIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT floatIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT floatIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT floatIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT floatIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT floatIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT floatIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT floatIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT floatIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT floatIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT floatIn(null);

-- from * to decimal(3, 0)
DROP FUNCTION IF EXISTS decimal3_0In;
CREATE FUNCTION decimal3_0In(decimal(3, 0)) RETURNS decimal(3, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal3_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal3_0In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal3_0In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal3_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal3_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal3_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal3_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal3_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT decimal3_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT decimal3_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal3_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal3_0In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal3_0In(null);

-- from * to decimal(5, 0)
DROP FUNCTION IF EXISTS decimal5_0In;
CREATE FUNCTION decimal5_0In(decimal(5, 0)) RETURNS decimal(5, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal5_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal5_0In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal5_0In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal5_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal5_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal5_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal5_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal5_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT decimal5_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT decimal5_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal5_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal5_0In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal5_0In(null);

-- from * to decimal(10, 0)
DROP FUNCTION IF EXISTS decimal10_0In;
CREATE FUNCTION decimal10_0In(decimal(10, 0)) RETURNS decimal(10, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal10_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal10_0In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal10_0In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal10_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal10_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal10_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal10_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal10_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT decimal10_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT decimal10_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal10_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal10_0In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_0In(null);

-- from * to decimal(10, 2)
DROP FUNCTION IF EXISTS decimal10_2In;
CREATE FUNCTION decimal10_2In(decimal(10, 2)) RETURNS decimal(10, 2)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal10_2In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal10_2In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal10_2In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal10_2In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal10_2In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal10_2In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal10_2In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal10_2In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal10_2In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
SELECT decimal10_2In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal10_2In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal10_2In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal10_2In(null);

-- from * to decimal(20, 0)
DROP FUNCTION IF EXISTS decimal20_0In;
CREATE FUNCTION decimal20_0In(decimal(20, 0)) RETURNS decimal(20, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal20_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal20_0In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal20_0In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal20_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal20_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal20_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal20_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal20_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal20_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT decimal20_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal20_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal20_0In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal20_0In(null);

-- from * to decimal(30, 15)
DROP FUNCTION IF EXISTS decimal30_15In;
CREATE FUNCTION decimal30_15In(decimal(30, 15)) RETURNS decimal(30, 15)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal30_15In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal30_15In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal30_15In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal30_15In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal30_15In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal30_15In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal30_15In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal30_15In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal30_15In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT decimal30_15In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
SELECT decimal30_15In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal30_15In(null);

-- from * to decimal(14, 7)
DROP FUNCTION IF EXISTS decimal14_7In;
CREATE FUNCTION decimal14_7In(decimal(14, 7)) RETURNS decimal(14, 7)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT decimal14_7In(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT decimal14_7In(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT decimal14_7In(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT decimal14_7In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT decimal14_7In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT decimal14_7In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT decimal14_7In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT decimal14_7In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT decimal14_7In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT decimal14_7In(binaryVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(booleanVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(stringVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(dateVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(timestampVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT decimal14_7In(null);

-- from * to binary
DROP FUNCTION IF EXISTS binaryIn;
CREATE FUNCTION binaryIn(bytea) RETURNS bytea
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT binaryIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT binaryIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT binaryIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT binaryIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT binaryIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT binaryIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT binaryIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT binaryIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT binaryIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT binaryIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT binaryIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT binaryIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT binaryIn(null);

-- from * to boolean
DROP FUNCTION IF EXISTS booleanIn;
CREATE FUNCTION booleanIn(boolean) RETURNS boolean
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT booleanIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT booleanIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT booleanIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT booleanIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT booleanIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT booleanIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT booleanIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT booleanIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT booleanIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT booleanIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT booleanIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT booleanIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT booleanIn(null);

-- from * to string
DROP FUNCTION IF EXISTS stringIn;
CREATE FUNCTION stringIn(text) RETURNS text
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT stringIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT stringIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT stringIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT stringIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT stringIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT stringIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT stringIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT stringIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT stringIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT stringIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT stringIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT stringIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT stringIn(null);

-- from * to date
DROP FUNCTION IF EXISTS dateIn;
CREATE FUNCTION dateIn(date) RETURNS date
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT dateIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT dateIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT dateIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT dateIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT dateIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT dateIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT dateIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT dateIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT dateIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT dateIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT dateIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT dateIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT dateIn(null);

-- from * to timestamp
DROP FUNCTION IF EXISTS timestampIn;
CREATE FUNCTION timestampIn(timestamp) RETURNS timestamp
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT timestampIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT timestampIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT timestampIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT timestampIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT timestampIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT timestampIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT timestampIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT timestampIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT timestampIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT timestampIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT timestampIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT timestampIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT timestampIn(null);

-- from * to int[]
DROP FUNCTION IF EXISTS arrayIntIn;
CREATE FUNCTION arrayIntIn(int[]) RETURNS int[]
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT arrayIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT arrayIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT arrayIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT arrayIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT arrayIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT arrayIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT arrayIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT arrayIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT arrayIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT arrayIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT arrayIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT arrayIntIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT arrayIntIn(null);

-- from * to float8[]
DROP FUNCTION IF EXISTS arrayDoubleIn;
CREATE FUNCTION arrayDoubleIn(float8[]) RETURNS float8[]
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT arrayDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT arrayDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT arrayDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT arrayDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT arrayDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT arrayDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT arrayDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT arrayDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT arrayDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT arrayDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT arrayDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT arrayDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT arrayDoubleIn(null);

-- from * to structIntDoubleTy
DROP FUNCTION IF EXISTS structIntDoubleIn;
CREATE FUNCTION structIntDoubleIn(structIntDoubleTy) RETURNS structIntDoubleTy
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT structIntDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT structIntDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT structIntDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT structIntDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT structIntDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT structIntDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT structIntDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT structIntDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT structIntDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT structIntDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT structIntDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT structIntDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
SELECT structIntDoubleIn(null);

-- from * to structStringIntTy
DROP FUNCTION IF EXISTS structStringIntIn;
CREATE FUNCTION structStringIntIn(structStringIntTy) RETURNS structStringIntTy
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;

SELECT structStringIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
SELECT structStringIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
SELECT structStringIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
SELECT structStringIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
SELECT structStringIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
SELECT structStringIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
SELECT structStringIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
SELECT structStringIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
SELECT structStringIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
SELECT structStringIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT structStringIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
SELECT structStringIntIn(binaryVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(booleanVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(stringVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(dateVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(timestampVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(arrayIntVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
SELECT structStringIntIn(null);