-- psql -d postgres -a -f implicitCasts.sql > result.log 2>&1
\pset null 'NULL'
Null display is "NULL".
DROP TYPE IF EXISTS structIntDoubleTy;
psql:implicitCasts.sql:4: ERROR:  cannot drop type structintdoublety because other objects depend on it
DETAIL:  column structintdoubleval of table dststructintdoublevaltable depends on type structintdoublety
column structintdoubleval of table srctesttable depends on type structintdoublety
function structintdoublein(structintdoublety) depends on type structintdoublety
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
DROP TYPE IF EXISTS structStringIntTy;
psql:implicitCasts.sql:5: ERROR:  cannot drop type structstringintty because other objects depend on it
DETAIL:  column structstringintval of table dststructstringintvaltable depends on type structstringintty
column structstringintval of table srctesttable depends on type structstringintty
function structstringintin(structstringintty) depends on type structstringintty
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
CREATE TYPE structIntDoubleTy AS (
  d0 int,
  d1 float8
);
psql:implicitCasts.sql:10: ERROR:  type "structintdoublety" already exists
CREATE TYPE structStringIntTy AS (
  d0 text,
  d1 int
);
psql:implicitCasts.sql:15: ERROR:  type "structstringintty" already exists
DROP TABLE IF EXISTS srcTestTable;
DROP TABLE
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
);
CREATE TABLE
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 0 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)
);
INSERT 0 1
SELECT * FROM srcTestTable;
 shortval |   intval   |       longval       |   doubleval   |  floatval   | decimal3_0val | decimal5_0val | decimal10_0val | decimal10_2val |   decimal20_0val    |         decimal30_15val         | decimal14_7val  | binaryval | booleanval | stringval |  dateval   |    timestampval     | arrayintval | arraydoubleval | structintdoubleval | structstringintval
----------+------------+---------------------+---------------+-------------+---------------+---------------+----------------+----------------+---------------------+---------------------------------+-----------------+-----------+------------+-----------+------------+---------------------+-------------+----------------+--------------------+--------------------
        1 |          1 |                   1 |             1 |           1 |             1 |             1 |              1 |           1.00 |                   1 |               1.000000000000000 |       1.0000000 | \x616263  | t          | abc       | 1970-01-01 | 1970-01-01 00:00:00 | {1,2,3}     | {1,2,3}        | (1,1)              | (a,1)
    32767 | 2147483647 | 9223372036854775807 | 1.797693e+308 | 3.40282e+38 |           999 |         99999 |     9999999999 |       99999.99 | 9999999999999999999 | 999999999999999.999999999999999 | 9999999.9999999 | \x646566  | f          | def       | 2018-07-06 | 2018-07-06 00:00:00 | {4,5,6}     | {4,5,6}        | (2,2)              | (b,2)
(2 rows)

-- binary arithmetic expression cases
-- (short, *)
SELECT pg_typeof(shortVal * intVal) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 integer
(1 row)

SELECT pg_typeof(shortVal * longVal) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 bigint
(1 row)

SELECT pg_typeof(shortVal * doubleVal) FROM srcTestTable WHERE shortVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(shortVal * floatVal) FROM srcTestTable WHERE shortVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(shortVal * decimal3_0Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal5_0Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal10_0Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal10_2Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal20_0Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal30_15Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(shortVal * decimal14_7Val) FROM srcTestTable WHERE shortVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- (int, *)
SELECT pg_typeof(intVal * longVal) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 bigint
(1 row)

SELECT pg_typeof(intVal * doubleVal) FROM srcTestTable WHERE intVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(intVal * floatVal) FROM srcTestTable WHERE intVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(intVal * decimal3_0Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal5_0Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal10_0Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal10_2Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal20_0Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal30_15Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(intVal * decimal14_7Val) FROM srcTestTable WHERE intVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- (long, *)
SELECT pg_typeof(longVal * doubleVal) FROM srcTestTable WHERE longVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(longVal * floatVal) FROM srcTestTable WHERE longVal = 1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(longVal * decimal3_0Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal5_0Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal10_0Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal10_2Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal20_0Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal30_15Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(longVal * decimal14_7Val) FROM srcTestTable WHERE longVal = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- (double, *)
SELECT pg_typeof(doubleVal * floatVal) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal3_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal5_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal10_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal10_2Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal20_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal30_15Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(doubleVal * decimal14_7Val) FROM srcTestTable WHERE doubleVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

-- (float, *)
SELECT pg_typeof(floatVal * decimal3_0Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal5_0Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal10_0Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal10_2Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal20_0Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal30_15Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

SELECT pg_typeof(floatVal * decimal14_7Val) FROM srcTestTable WHERE floatVal < 1.1;
    pg_typeof
------------------
 double precision
(1 row)

-- (decimal(3, 0), *)
SELECT pg_typeof(decimal3_0Val * decimal5_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal3_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal3_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal3_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal3_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal3_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- (decimal(5, 0), *)
SELECT pg_typeof(decimal5_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal5_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal5_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal5_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal5_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- (decimal(10, 0), *)
SELECT pg_typeof(decimal10_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal10_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal10_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal10_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

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

SELECT pg_typeof(decimal10_2Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

SELECT pg_typeof(decimal10_2Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

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

SELECT pg_typeof(decimal30_15Val * decimal14_7Val) FROM srcTestTable WHERE decimal30_15Val = 1;
 pg_typeof
-----------
 numeric
(1 row)

-- binary arithmetic expression cases
-- (binary, *)
SELECT pg_typeof(binaryVal || shortVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:147: ERROR:  operator does not exist: bytea || smallint
LINE 1: SELECT pg_typeof(binaryVal || shortVal) FROM srcTestTable LI...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || intVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:148: ERROR:  operator does not exist: bytea || integer
LINE 1: SELECT pg_typeof(binaryVal || intVal) FROM srcTestTable LIMI...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || longVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:149: ERROR:  operator does not exist: bytea || bigint
LINE 1: SELECT pg_typeof(binaryVal || longVal) FROM srcTestTable LIM...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || doubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:150: ERROR:  operator does not exist: bytea || double precision
LINE 1: SELECT pg_typeof(binaryVal || doubleVal) FROM srcTestTable L...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || floatVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:151: ERROR:  operator does not exist: bytea || real
LINE 1: SELECT pg_typeof(binaryVal || floatVal) FROM srcTestTable LI...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:152: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal3_0Val) FROM srcTestTab...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:153: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal5_0Val) FROM srcTestTab...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:154: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal10_0Val) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:155: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal10_2Val) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:156: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal20_0Val) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:157: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal30_15Val) FROM srcTestT...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:158: ERROR:  operator does not exist: bytea || numeric
LINE 1: SELECT pg_typeof(binaryVal || decimal14_7Val) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:159: ERROR:  operator does not exist: bytea || boolean
LINE 1: SELECT pg_typeof(binaryVal || booleanVal) FROM srcTestTable ...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || stringVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(binaryVal || dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:161: ERROR:  operator does not exist: bytea || date
LINE 1: SELECT pg_typeof(binaryVal || dateVal) FROM srcTestTable LIM...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:162: ERROR:  operator does not exist: bytea || timestamp without time zone
LINE 1: SELECT pg_typeof(binaryVal || timestampVal) FROM srcTestTabl...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:163: ERROR:  operator does not exist: bytea || integer[]
LINE 1: SELECT pg_typeof(binaryVal || arrayIntVal) FROM srcTestTable...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:164: ERROR:  operator does not exist: bytea || double precision[]
LINE 1: SELECT pg_typeof(binaryVal || arrayDoubleVal) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:165: ERROR:  operator does not exist: bytea || structintdoublety
LINE 1: SELECT pg_typeof(binaryVal || structIntDoubleVal) FROM srcTe...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(binaryVal || structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:166: ERROR:  operator does not exist: bytea || structstringintty
LINE 1: SELECT pg_typeof(binaryVal || structStringIntVal) FROM srcTe...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
-- (text, *)
SELECT pg_typeof(stringVal || shortVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || intVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || longVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || doubleVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || floatVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || booleanVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || stringVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || dateVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || timestampVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:185: ERROR:  operator does not exist: text || integer[]
LINE 1: SELECT pg_typeof(stringVal || arrayIntVal) FROM srcTestTable...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(stringVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:186: ERROR:  operator does not exist: text || double precision[]
LINE 1: SELECT pg_typeof(stringVal || arrayDoubleVal) FROM srcTestTa...
                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT pg_typeof(stringVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

SELECT pg_typeof(stringVal || structStringIntVal) FROM srcTestTable LIMIT 1;
 pg_typeof
-----------
 text
(1 row)

-- function inputs
-- from * to short
DROP FUNCTION IF EXISTS shortIn;
DROP FUNCTION
CREATE FUNCTION shortIn(smallint) RETURNS smallint
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT shortIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:201: ERROR:  function shortin(integer) does not exist
LINE 1: SELECT shortIn(intVal) FROM srcTestTable WHERE intVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:202: ERROR:  function shortin(bigint) does not exist
LINE 1: SELECT shortIn(longVal) FROM srcTestTable WHERE longVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:203: ERROR:  function shortin(double precision) does not exist
LINE 1: SELECT shortIn(doubleVal) FROM srcTestTable WHERE doubleVal ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
psql:implicitCasts.sql:204: ERROR:  function shortin(real) does not exist
LINE 1: SELECT shortIn(floatVal) FROM srcTestTable WHERE floatVal < ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:205: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal3_0Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:206: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal5_0Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:207: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal10_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:208: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal10_2Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
psql:implicitCasts.sql:209: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal20_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:210: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal30_15Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
psql:implicitCasts.sql:211: ERROR:  function shortin(numeric) does not exist
LINE 1: SELECT shortIn(decimal14_7Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:212: ERROR:  function shortin(bytea) does not exist
LINE 1: SELECT shortIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:213: ERROR:  function shortin(boolean) does not exist
LINE 1: SELECT shortIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:214: ERROR:  function shortin(text) does not exist
LINE 1: SELECT shortIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:215: ERROR:  function shortin(date) does not exist
LINE 1: SELECT shortIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:216: ERROR:  function shortin(timestamp without time zone) does not exist
LINE 1: SELECT shortIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:217: ERROR:  function shortin(integer[]) does not exist
LINE 1: SELECT shortIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:218: ERROR:  function shortin(double precision[]) does not exist
LINE 1: SELECT shortIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:219: ERROR:  function shortin(structintdoublety) does not exist
LINE 1: SELECT shortIn(structIntDoubleVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:220: ERROR:  function shortin(structstringintty) does not exist
LINE 1: SELECT shortIn(structStringIntVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT shortIn(null);
 shortin
---------
    NULL
(1 row)

-- from * to int
DROP FUNCTION IF EXISTS intIn;
DROP FUNCTION
CREATE FUNCTION intIn(int) RETURNS int
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT intIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
 intin
-------
     1
(1 row)

SELECT intIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:232: ERROR:  function intin(bigint) does not exist
LINE 1: SELECT intIn(longVal) FROM srcTestTable WHERE longVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:233: ERROR:  function intin(double precision) does not exist
LINE 1: SELECT intIn(doubleVal) FROM srcTestTable WHERE doubleVal < ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
psql:implicitCasts.sql:234: ERROR:  function intin(real) does not exist
LINE 1: SELECT intIn(floatVal) FROM srcTestTable WHERE floatVal < 1....
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:235: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal3_0Val) FROM srcTestTable WHERE decimal3...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:236: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal5_0Val) FROM srcTestTable WHERE decimal5...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:237: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal10_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:238: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal10_2Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
psql:implicitCasts.sql:239: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal20_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:240: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal30_15Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
psql:implicitCasts.sql:241: ERROR:  function intin(numeric) does not exist
LINE 1: SELECT intIn(decimal14_7Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:242: ERROR:  function intin(bytea) does not exist
LINE 1: SELECT intIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:243: ERROR:  function intin(boolean) does not exist
LINE 1: SELECT intIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:244: ERROR:  function intin(text) does not exist
LINE 1: SELECT intIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:245: ERROR:  function intin(date) does not exist
LINE 1: SELECT intIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:246: ERROR:  function intin(timestamp without time zone) does not exist
LINE 1: SELECT intIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:247: ERROR:  function intin(integer[]) does not exist
LINE 1: SELECT intIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:248: ERROR:  function intin(double precision[]) does not exist
LINE 1: SELECT intIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:249: ERROR:  function intin(structintdoublety) does not exist
LINE 1: SELECT intIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:250: ERROR:  function intin(structstringintty) does not exist
LINE 1: SELECT intIn(structStringIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT intIn(null);
 intin
-------
  NULL
(1 row)

-- from * to long
DROP FUNCTION IF EXISTS longIn;
DROP FUNCTION
CREATE FUNCTION longIn(bigint) RETURNS bigint
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT longIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
 longin
--------
      1
(1 row)

SELECT longIn(intVal) FROM srcTestTable WHERE intVal = 1;
 longin
--------
      1
(1 row)

SELECT longIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:263: ERROR:  function longin(double precision) does not exist
LINE 1: SELECT longIn(doubleVal) FROM srcTestTable WHERE doubleVal <...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
psql:implicitCasts.sql:264: ERROR:  function longin(real) does not exist
LINE 1: SELECT longIn(floatVal) FROM srcTestTable WHERE floatVal < 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:265: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal3_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:266: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal5_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:267: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal10_0Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:268: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal10_2Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
psql:implicitCasts.sql:269: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal20_0Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:270: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal30_15Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
psql:implicitCasts.sql:271: ERROR:  function longin(numeric) does not exist
LINE 1: SELECT longIn(decimal14_7Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:272: ERROR:  function longin(bytea) does not exist
LINE 1: SELECT longIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:273: ERROR:  function longin(boolean) does not exist
LINE 1: SELECT longIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:274: ERROR:  function longin(text) does not exist
LINE 1: SELECT longIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:275: ERROR:  function longin(date) does not exist
LINE 1: SELECT longIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:276: ERROR:  function longin(timestamp without time zone) does not exist
LINE 1: SELECT longIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:277: ERROR:  function longin(integer[]) does not exist
LINE 1: SELECT longIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:278: ERROR:  function longin(double precision[]) does not exist
LINE 1: SELECT longIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:279: ERROR:  function longin(structintdoublety) does not exist
LINE 1: SELECT longIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:280: ERROR:  function longin(structstringintty) does not exist
LINE 1: SELECT longIn(structStringIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT longIn(null);
 longin
--------
   NULL
(1 row)

-- from * to float8
DROP FUNCTION IF EXISTS doubleIn;
DROP FUNCTION
CREATE FUNCTION doubleIn(float8) RETURNS float8
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT doubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 doublein
----------
        1
(1 row)

SELECT doubleIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:302: ERROR:  function doublein(bytea) does not exist
LINE 1: SELECT doubleIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:303: ERROR:  function doublein(boolean) does not exist
LINE 1: SELECT doubleIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:304: ERROR:  function doublein(text) does not exist
LINE 1: SELECT doubleIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:305: ERROR:  function doublein(date) does not exist
LINE 1: SELECT doubleIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:306: ERROR:  function doublein(timestamp without time zone) does not exist
LINE 1: SELECT doubleIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:307: ERROR:  function doublein(integer[]) does not exist
LINE 1: SELECT doubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:308: ERROR:  function doublein(double precision[]) does not exist
LINE 1: SELECT doubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:309: ERROR:  function doublein(structintdoublety) does not exist
LINE 1: SELECT doubleIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:310: ERROR:  function doublein(structstringintty) does not exist
LINE 1: SELECT doubleIn(structStringIntVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT doubleIn(null);
 doublein
----------
     NULL
(1 row)

-- from * to float4
DROP FUNCTION IF EXISTS floatIn;
DROP FUNCTION
CREATE FUNCTION floatIn(float4) RETURNS float4
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT floatIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(intVal) FROM srcTestTable WHERE intVal = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(longVal) FROM srcTestTable WHERE longVal = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:324: ERROR:  function floatin(double precision) does not exist
LINE 1: SELECT floatIn(doubleVal) FROM srcTestTable WHERE doubleVal ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 floatin
---------
       1
(1 row)

SELECT floatIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:332: ERROR:  function floatin(bytea) does not exist
LINE 1: SELECT floatIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:333: ERROR:  function floatin(boolean) does not exist
LINE 1: SELECT floatIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:334: ERROR:  function floatin(text) does not exist
LINE 1: SELECT floatIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:335: ERROR:  function floatin(date) does not exist
LINE 1: SELECT floatIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:336: ERROR:  function floatin(timestamp without time zone) does not exist
LINE 1: SELECT floatIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:337: ERROR:  function floatin(integer[]) does not exist
LINE 1: SELECT floatIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:338: ERROR:  function floatin(double precision[]) does not exist
LINE 1: SELECT floatIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:339: ERROR:  function floatin(structintdoublety) does not exist
LINE 1: SELECT floatIn(structIntDoubleVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:340: ERROR:  function floatin(structstringintty) does not exist
LINE 1: SELECT floatIn(structStringIntVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT floatIn(null);
 floatin
---------
    NULL
(1 row)

-- from * to decimal(3, 0)
DROP FUNCTION IF EXISTS decimal3_0In;
DROP FUNCTION
CREATE FUNCTION decimal3_0In(decimal(3, 0)) RETURNS decimal(3, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal3_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:354: ERROR:  function decimal3_0in(double precision) does not exist
LINE 1: SELECT decimal3_0In(doubleVal) FROM srcTestTable WHERE doubl...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:355: ERROR:  function decimal3_0in(real) does not exist
LINE 1: SELECT decimal3_0In(floatVal) FROM srcTestTable WHERE floatV...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 decimal3_0in
--------------
         1.00
(1 row)

SELECT decimal3_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 decimal3_0in
--------------
            1
(1 row)

SELECT decimal3_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal3_0in
-------------------
 1.000000000000000
(1 row)

SELECT decimal3_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal3_0in
--------------
    1.0000000
(1 row)

SELECT decimal3_0In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:362: ERROR:  function decimal3_0in(bytea) does not exist
LINE 1: SELECT decimal3_0In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:363: ERROR:  function decimal3_0in(boolean) does not exist
LINE 1: SELECT decimal3_0In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:364: ERROR:  function decimal3_0in(text) does not exist
LINE 1: SELECT decimal3_0In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:365: ERROR:  function decimal3_0in(date) does not exist
LINE 1: SELECT decimal3_0In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:366: ERROR:  function decimal3_0in(timestamp without time zone) does not exist
LINE 1: SELECT decimal3_0In(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:367: ERROR:  function decimal3_0in(integer[]) does not exist
LINE 1: SELECT decimal3_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:368: ERROR:  function decimal3_0in(double precision[]) does not exist
LINE 1: SELECT decimal3_0In(arrayDoubleVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:369: ERROR:  function decimal3_0in(structintdoublety) does not exist
LINE 1: SELECT decimal3_0In(structIntDoubleVal) FROM srcTestTable LI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:370: ERROR:  function decimal3_0in(structstringintty) does not exist
LINE 1: SELECT decimal3_0In(structStringIntVal) FROM srcTestTable LI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal3_0In(null);
 decimal3_0in
--------------
         NULL
(1 row)

-- from * to decimal(5, 0)
DROP FUNCTION IF EXISTS decimal5_0In;
DROP FUNCTION
CREATE FUNCTION decimal5_0In(decimal(5, 0)) RETURNS decimal(5, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal5_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:384: ERROR:  function decimal5_0in(double precision) does not exist
LINE 1: SELECT decimal5_0In(doubleVal) FROM srcTestTable WHERE doubl...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:385: ERROR:  function decimal5_0in(real) does not exist
LINE 1: SELECT decimal5_0In(floatVal) FROM srcTestTable WHERE floatV...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 decimal5_0in
--------------
         1.00
(1 row)

SELECT decimal5_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 decimal5_0in
--------------
            1
(1 row)

SELECT decimal5_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal5_0in
-------------------
 1.000000000000000
(1 row)

SELECT decimal5_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal5_0in
--------------
    1.0000000
(1 row)

SELECT decimal5_0In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:392: ERROR:  function decimal5_0in(bytea) does not exist
LINE 1: SELECT decimal5_0In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:393: ERROR:  function decimal5_0in(boolean) does not exist
LINE 1: SELECT decimal5_0In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:394: ERROR:  function decimal5_0in(text) does not exist
LINE 1: SELECT decimal5_0In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:395: ERROR:  function decimal5_0in(date) does not exist
LINE 1: SELECT decimal5_0In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:396: ERROR:  function decimal5_0in(timestamp without time zone) does not exist
LINE 1: SELECT decimal5_0In(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:397: ERROR:  function decimal5_0in(integer[]) does not exist
LINE 1: SELECT decimal5_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:398: ERROR:  function decimal5_0in(double precision[]) does not exist
LINE 1: SELECT decimal5_0In(arrayDoubleVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:399: ERROR:  function decimal5_0in(structintdoublety) does not exist
LINE 1: SELECT decimal5_0In(structIntDoubleVal) FROM srcTestTable LI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:400: ERROR:  function decimal5_0in(structstringintty) does not exist
LINE 1: SELECT decimal5_0In(structStringIntVal) FROM srcTestTable LI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal5_0In(null);
 decimal5_0in
--------------
         NULL
(1 row)

-- from * to decimal(10, 0)
DROP FUNCTION IF EXISTS decimal10_0In;
DROP FUNCTION
CREATE FUNCTION decimal10_0In(decimal(10, 0)) RETURNS decimal(10, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal10_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:414: ERROR:  function decimal10_0in(double precision) does not exist
LINE 1: SELECT decimal10_0In(doubleVal) FROM srcTestTable WHERE doub...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:415: ERROR:  function decimal10_0in(real) does not exist
LINE 1: SELECT decimal10_0In(floatVal) FROM srcTestTable WHERE float...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 decimal10_0in
---------------
          1.00
(1 row)

SELECT decimal10_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 decimal10_0in
---------------
             1
(1 row)

SELECT decimal10_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal10_0in
-------------------
 1.000000000000000
(1 row)

SELECT decimal10_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal10_0in
---------------
     1.0000000
(1 row)

SELECT decimal10_0In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:422: ERROR:  function decimal10_0in(bytea) does not exist
LINE 1: SELECT decimal10_0In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:423: ERROR:  function decimal10_0in(boolean) does not exist
LINE 1: SELECT decimal10_0In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:424: ERROR:  function decimal10_0in(text) does not exist
LINE 1: SELECT decimal10_0In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:425: ERROR:  function decimal10_0in(date) does not exist
LINE 1: SELECT decimal10_0In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:426: ERROR:  function decimal10_0in(timestamp without time zone) does not exist
LINE 1: SELECT decimal10_0In(timestampVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:427: ERROR:  function decimal10_0in(integer[]) does not exist
LINE 1: SELECT decimal10_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:428: ERROR:  function decimal10_0in(double precision[]) does not exist
LINE 1: SELECT decimal10_0In(arrayDoubleVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:429: ERROR:  function decimal10_0in(structintdoublety) does not exist
LINE 1: SELECT decimal10_0In(structIntDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:430: ERROR:  function decimal10_0in(structstringintty) does not exist
LINE 1: SELECT decimal10_0In(structStringIntVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_0In(null);
 decimal10_0in
---------------
          NULL
(1 row)

-- from * to decimal(10, 2)
DROP FUNCTION IF EXISTS decimal10_2In;
DROP FUNCTION
CREATE FUNCTION decimal10_2In(decimal(10, 2)) RETURNS decimal(10, 2)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal10_2In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:444: ERROR:  function decimal10_2in(double precision) does not exist
LINE 1: SELECT decimal10_2In(doubleVal) FROM srcTestTable WHERE doub...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:445: ERROR:  function decimal10_2in(real) does not exist
LINE 1: SELECT decimal10_2In(floatVal) FROM srcTestTable WHERE float...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
 decimal10_2in
---------------
             1
(1 row)

SELECT decimal10_2In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal10_2in
-------------------
 1.000000000000000
(1 row)

SELECT decimal10_2In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal10_2in
---------------
     1.0000000
(1 row)

SELECT decimal10_2In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:452: ERROR:  function decimal10_2in(bytea) does not exist
LINE 1: SELECT decimal10_2In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:453: ERROR:  function decimal10_2in(boolean) does not exist
LINE 1: SELECT decimal10_2In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:454: ERROR:  function decimal10_2in(text) does not exist
LINE 1: SELECT decimal10_2In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:455: ERROR:  function decimal10_2in(date) does not exist
LINE 1: SELECT decimal10_2In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:456: ERROR:  function decimal10_2in(timestamp without time zone) does not exist
LINE 1: SELECT decimal10_2In(timestampVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:457: ERROR:  function decimal10_2in(integer[]) does not exist
LINE 1: SELECT decimal10_2In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:458: ERROR:  function decimal10_2in(double precision[]) does not exist
LINE 1: SELECT decimal10_2In(arrayDoubleVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:459: ERROR:  function decimal10_2in(structintdoublety) does not exist
LINE 1: SELECT decimal10_2In(structIntDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:460: ERROR:  function decimal10_2in(structstringintty) does not exist
LINE 1: SELECT decimal10_2In(structStringIntVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal10_2In(null);
 decimal10_2in
---------------
          NULL
(1 row)

-- from * to decimal(20, 0)
DROP FUNCTION IF EXISTS decimal20_0In;
DROP FUNCTION
CREATE FUNCTION decimal20_0In(decimal(20, 0)) RETURNS decimal(20, 0)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal20_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:474: ERROR:  function decimal20_0in(double precision) does not exist
LINE 1: SELECT decimal20_0In(doubleVal) FROM srcTestTable WHERE doub...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:475: ERROR:  function decimal20_0in(real) does not exist
LINE 1: SELECT decimal20_0In(floatVal) FROM srcTestTable WHERE float...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal20_0in
---------------
             1
(1 row)

SELECT decimal20_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 decimal20_0in
---------------
          1.00
(1 row)

SELECT decimal20_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal20_0in
-------------------
 1.000000000000000
(1 row)

SELECT decimal20_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal20_0in
---------------
     1.0000000
(1 row)

SELECT decimal20_0In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:482: ERROR:  function decimal20_0in(bytea) does not exist
LINE 1: SELECT decimal20_0In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:483: ERROR:  function decimal20_0in(boolean) does not exist
LINE 1: SELECT decimal20_0In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:484: ERROR:  function decimal20_0in(text) does not exist
LINE 1: SELECT decimal20_0In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:485: ERROR:  function decimal20_0in(date) does not exist
LINE 1: SELECT decimal20_0In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:486: ERROR:  function decimal20_0in(timestamp without time zone) does not exist
LINE 1: SELECT decimal20_0In(timestampVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:487: ERROR:  function decimal20_0in(integer[]) does not exist
LINE 1: SELECT decimal20_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:488: ERROR:  function decimal20_0in(double precision[]) does not exist
LINE 1: SELECT decimal20_0In(arrayDoubleVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:489: ERROR:  function decimal20_0in(structintdoublety) does not exist
LINE 1: SELECT decimal20_0In(structIntDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:490: ERROR:  function decimal20_0in(structstringintty) does not exist
LINE 1: SELECT decimal20_0In(structStringIntVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal20_0In(null);
 decimal20_0in
---------------
          NULL
(1 row)

-- from * to decimal(30, 15)
DROP FUNCTION IF EXISTS decimal30_15In;
DROP FUNCTION
CREATE FUNCTION decimal30_15In(decimal(30, 15)) RETURNS decimal(30, 15)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal30_15In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:504: ERROR:  function decimal30_15in(double precision) does not exist
LINE 1: SELECT decimal30_15In(doubleVal) FROM srcTestTable WHERE dou...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:505: ERROR:  function decimal30_15in(real) does not exist
LINE 1: SELECT decimal30_15In(floatVal) FROM srcTestTable WHERE floa...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal30_15in
----------------
              1
(1 row)

SELECT decimal30_15In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
 decimal30_15in
----------------
           1.00
(1 row)

SELECT decimal30_15In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
 decimal30_15in
----------------
      1.0000000
(1 row)

SELECT decimal30_15In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:511: ERROR:  function decimal30_15in(bytea) does not exist
LINE 1: SELECT decimal30_15In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:512: ERROR:  function decimal30_15in(boolean) does not exist
LINE 1: SELECT decimal30_15In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:513: ERROR:  function decimal30_15in(text) does not exist
LINE 1: SELECT decimal30_15In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:514: ERROR:  function decimal30_15in(date) does not exist
LINE 1: SELECT decimal30_15In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:515: ERROR:  function decimal30_15in(timestamp without time zone) does not exist
LINE 1: SELECT decimal30_15In(timestampVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:516: ERROR:  function decimal30_15in(integer[]) does not exist
LINE 1: SELECT decimal30_15In(arrayIntVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:517: ERROR:  function decimal30_15in(double precision[]) does not exist
LINE 1: SELECT decimal30_15In(arrayDoubleVal) FROM srcTestTable LIMI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:518: ERROR:  function decimal30_15in(structintdoublety) does not exist
LINE 1: SELECT decimal30_15In(structIntDoubleVal) FROM srcTestTable ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:519: ERROR:  function decimal30_15in(structstringintty) does not exist
LINE 1: SELECT decimal30_15In(structStringIntVal) FROM srcTestTable ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal30_15In(null);
 decimal30_15in
----------------
           NULL
(1 row)

-- from * to decimal(14, 7)
DROP FUNCTION IF EXISTS decimal14_7In;
DROP FUNCTION
CREATE FUNCTION decimal14_7In(decimal(14, 7)) RETURNS decimal(14, 7)
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT decimal14_7In(shortVal) FROM srcTestTable WHERE shortVal = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(intVal) FROM srcTestTable WHERE intVal = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(longVal) FROM srcTestTable WHERE longVal = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:533: ERROR:  function decimal14_7in(double precision) does not exist
LINE 1: SELECT decimal14_7In(doubleVal) FROM srcTestTable WHERE doub...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:534: ERROR:  function decimal14_7in(real) does not exist
LINE 1: SELECT decimal14_7In(floatVal) FROM srcTestTable WHERE float...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
 decimal14_7in
---------------
             1
(1 row)

SELECT decimal14_7In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
   decimal14_7in
-------------------
 1.000000000000000
(1 row)

SELECT decimal14_7In(decimal30_15Val::decimal(14, 7)) FROM srcTestTable WHERE decimal30_15Val = 1;
 decimal14_7in
---------------
     1.0000000
(1 row)

SELECT decimal14_7In(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:540: ERROR:  function decimal14_7in(bytea) does not exist
LINE 1: SELECT decimal14_7In(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:541: ERROR:  function decimal14_7in(boolean) does not exist
LINE 1: SELECT decimal14_7In(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:542: ERROR:  function decimal14_7in(text) does not exist
LINE 1: SELECT decimal14_7In(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:543: ERROR:  function decimal14_7in(date) does not exist
LINE 1: SELECT decimal14_7In(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:544: ERROR:  function decimal14_7in(timestamp without time zone) does not exist
LINE 1: SELECT decimal14_7In(timestampVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:545: ERROR:  function decimal14_7in(integer[]) does not exist
LINE 1: SELECT decimal14_7In(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:546: ERROR:  function decimal14_7in(double precision[]) does not exist
LINE 1: SELECT decimal14_7In(arrayDoubleVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:547: ERROR:  function decimal14_7in(structintdoublety) does not exist
LINE 1: SELECT decimal14_7In(structIntDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:548: ERROR:  function decimal14_7in(structstringintty) does not exist
LINE 1: SELECT decimal14_7In(structStringIntVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT decimal14_7In(null);
 decimal14_7in
---------------
          NULL
(1 row)

-- from * to binary
DROP FUNCTION IF EXISTS binaryIn;
DROP FUNCTION
CREATE FUNCTION binaryIn(bytea) RETURNS bytea
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT binaryIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:559: ERROR:  function binaryin(smallint) does not exist
LINE 1: SELECT binaryIn(shortVal) FROM srcTestTable WHERE shortVal =...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:560: ERROR:  function binaryin(integer) does not exist
LINE 1: SELECT binaryIn(intVal) FROM srcTestTable WHERE intVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:561: ERROR:  function binaryin(bigint) does not exist
LINE 1: SELECT binaryIn(longVal) FROM srcTestTable WHERE longVal = 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:562: ERROR:  function binaryin(double precision) does not exist
LINE 1: SELECT binaryIn(doubleVal) FROM srcTestTable WHERE doubleVal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:563: ERROR:  function binaryin(real) does not exist
LINE 1: SELECT binaryIn(floatVal) FROM srcTestTable WHERE floatVal< ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:564: ERROR:  function binaryin(numeric) does not exist
LINE 1: SELECT binaryIn(decimal3_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:565: ERROR:  function binaryin(numeric) does not exist
LINE 1: SELECT binaryIn(decimal5_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:566: ERROR:  function binaryin(numeric) does not exist
LINE 1: SELECT binaryIn(decimal10_0Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:567: ERROR:  function binaryin(numeric) does not exist
LINE 1: SELECT binaryIn(decimal10_2Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:568: ERROR:  function binaryin(numeric) does not exist
LINE 1: SELECT binaryIn(decimal30_15Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:569: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT binaryIn(decimal14_7In) FROM srcTestTable WHERE decim...
                        ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT binaryIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:570: ERROR:  function binaryin(boolean) does not exist
LINE 1: SELECT binaryIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:571: ERROR:  function binaryin(text) does not exist
LINE 1: SELECT binaryIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:572: ERROR:  function binaryin(date) does not exist
LINE 1: SELECT binaryIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:573: ERROR:  function binaryin(timestamp without time zone) does not exist
LINE 1: SELECT binaryIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:574: ERROR:  function binaryin(integer[]) does not exist
LINE 1: SELECT binaryIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:575: ERROR:  function binaryin(double precision[]) does not exist
LINE 1: SELECT binaryIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:576: ERROR:  function binaryin(structintdoublety) does not exist
LINE 1: SELECT binaryIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:577: ERROR:  function binaryin(structstringintty) does not exist
LINE 1: SELECT binaryIn(structStringIntVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT binaryIn(null);
 binaryin
----------
 NULL
(1 row)

-- from * to boolean
DROP FUNCTION IF EXISTS booleanIn;
DROP FUNCTION
CREATE FUNCTION booleanIn(boolean) RETURNS boolean
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT booleanIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:588: ERROR:  function booleanin(smallint) does not exist
LINE 1: SELECT booleanIn(shortVal) FROM srcTestTable WHERE shortVal ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:589: ERROR:  function booleanin(integer) does not exist
LINE 1: SELECT booleanIn(intVal) FROM srcTestTable WHERE intVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:590: ERROR:  function booleanin(bigint) does not exist
LINE 1: SELECT booleanIn(longVal) FROM srcTestTable WHERE longVal = ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:591: ERROR:  function booleanin(double precision) does not exist
LINE 1: SELECT booleanIn(doubleVal) FROM srcTestTable WHERE doubleVa...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:592: ERROR:  function booleanin(real) does not exist
LINE 1: SELECT booleanIn(floatVal) FROM srcTestTable WHERE floatVal<...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:593: ERROR:  function booleanin(numeric) does not exist
LINE 1: SELECT booleanIn(decimal3_0Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:594: ERROR:  function booleanin(numeric) does not exist
LINE 1: SELECT booleanIn(decimal5_0Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:595: ERROR:  function booleanin(numeric) does not exist
LINE 1: SELECT booleanIn(decimal10_0Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:596: ERROR:  function booleanin(numeric) does not exist
LINE 1: SELECT booleanIn(decimal10_2Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:597: ERROR:  function booleanin(numeric) does not exist
LINE 1: SELECT booleanIn(decimal30_15Val) FROM srcTestTable WHERE de...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:598: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT booleanIn(decimal14_7In) FROM srcTestTable WHERE deci...
                         ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT booleanIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:599: ERROR:  function booleanin(bytea) does not exist
LINE 1: SELECT booleanIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:600: ERROR:  function booleanin(text) does not exist
LINE 1: SELECT booleanIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:601: ERROR:  function booleanin(date) does not exist
LINE 1: SELECT booleanIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:602: ERROR:  function booleanin(timestamp without time zone) does not exist
LINE 1: SELECT booleanIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:603: ERROR:  function booleanin(integer[]) does not exist
LINE 1: SELECT booleanIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:604: ERROR:  function booleanin(double precision[]) does not exist
LINE 1: SELECT booleanIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:605: ERROR:  function booleanin(structintdoublety) does not exist
LINE 1: SELECT booleanIn(structIntDoubleVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:606: ERROR:  function booleanin(structstringintty) does not exist
LINE 1: SELECT booleanIn(structStringIntVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT booleanIn(null);
 booleanin
-----------
 NULL
(1 row)

-- from * to string
DROP FUNCTION IF EXISTS stringIn;
DROP FUNCTION
CREATE FUNCTION stringIn(text) RETURNS text
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT stringIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:617: ERROR:  function stringin(smallint) does not exist
LINE 1: SELECT stringIn(shortVal) FROM srcTestTable WHERE shortVal =...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:618: ERROR:  function stringin(integer) does not exist
LINE 1: SELECT stringIn(intVal) FROM srcTestTable WHERE intVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:619: ERROR:  function stringin(bigint) does not exist
LINE 1: SELECT stringIn(longVal) FROM srcTestTable WHERE longVal = 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:620: ERROR:  function stringin(double precision) does not exist
LINE 1: SELECT stringIn(doubleVal) FROM srcTestTable WHERE doubleVal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:621: ERROR:  function stringin(real) does not exist
LINE 1: SELECT stringIn(floatVal) FROM srcTestTable WHERE floatVal< ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:622: ERROR:  function stringin(numeric) does not exist
LINE 1: SELECT stringIn(decimal3_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:623: ERROR:  function stringin(numeric) does not exist
LINE 1: SELECT stringIn(decimal5_0Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:624: ERROR:  function stringin(numeric) does not exist
LINE 1: SELECT stringIn(decimal10_0Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:625: ERROR:  function stringin(numeric) does not exist
LINE 1: SELECT stringIn(decimal10_2Val) FROM srcTestTable WHERE deci...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:626: ERROR:  function stringin(numeric) does not exist
LINE 1: SELECT stringIn(decimal30_15Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:627: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT stringIn(decimal14_7In) FROM srcTestTable WHERE decim...
                        ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT stringIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:628: ERROR:  function stringin(bytea) does not exist
LINE 1: SELECT stringIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:629: ERROR:  function stringin(boolean) does not exist
LINE 1: SELECT stringIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:630: ERROR:  function stringin(date) does not exist
LINE 1: SELECT stringIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:631: ERROR:  function stringin(timestamp without time zone) does not exist
LINE 1: SELECT stringIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:632: ERROR:  function stringin(integer[]) does not exist
LINE 1: SELECT stringIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:633: ERROR:  function stringin(double precision[]) does not exist
LINE 1: SELECT stringIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:634: ERROR:  function stringin(structintdoublety) does not exist
LINE 1: SELECT stringIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:635: ERROR:  function stringin(structstringintty) does not exist
LINE 1: SELECT stringIn(structStringIntVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT stringIn(null);
 stringin
----------
 NULL
(1 row)

-- from * to date
DROP FUNCTION IF EXISTS dateIn;
DROP FUNCTION
CREATE FUNCTION dateIn(date) RETURNS date
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT dateIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:646: ERROR:  function datein(smallint) does not exist
LINE 1: SELECT dateIn(shortVal) FROM srcTestTable WHERE shortVal = 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:647: ERROR:  function datein(integer) does not exist
LINE 1: SELECT dateIn(intVal) FROM srcTestTable WHERE intVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:648: ERROR:  function datein(bigint) does not exist
LINE 1: SELECT dateIn(longVal) FROM srcTestTable WHERE longVal = 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:649: ERROR:  function datein(double precision) does not exist
LINE 1: SELECT dateIn(doubleVal) FROM srcTestTable WHERE doubleVal <...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:650: ERROR:  function datein(real) does not exist
LINE 1: SELECT dateIn(floatVal) FROM srcTestTable WHERE floatVal< 1....
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:651: ERROR:  function datein(numeric) does not exist
LINE 1: SELECT dateIn(decimal3_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:652: ERROR:  function datein(numeric) does not exist
LINE 1: SELECT dateIn(decimal5_0Val) FROM srcTestTable WHERE decimal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:653: ERROR:  function datein(numeric) does not exist
LINE 1: SELECT dateIn(decimal10_0Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:654: ERROR:  function datein(numeric) does not exist
LINE 1: SELECT dateIn(decimal10_2Val) FROM srcTestTable WHERE decima...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:655: ERROR:  function datein(numeric) does not exist
LINE 1: SELECT dateIn(decimal30_15Val) FROM srcTestTable WHERE decim...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:656: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT dateIn(decimal14_7In) FROM srcTestTable WHERE decimal...
                      ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT dateIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:657: ERROR:  function datein(bytea) does not exist
LINE 1: SELECT dateIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:658: ERROR:  function datein(boolean) does not exist
LINE 1: SELECT dateIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:659: ERROR:  function datein(text) does not exist
LINE 1: SELECT dateIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:660: ERROR:  function datein(timestamp without time zone) does not exist
LINE 1: SELECT dateIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:661: ERROR:  function datein(integer[]) does not exist
LINE 1: SELECT dateIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:662: ERROR:  function datein(double precision[]) does not exist
LINE 1: SELECT dateIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:663: ERROR:  function datein(structintdoublety) does not exist
LINE 1: SELECT dateIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:664: ERROR:  function datein(structstringintty) does not exist
LINE 1: SELECT dateIn(structStringIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT dateIn(null);
 datein
--------
 NULL
(1 row)

-- from * to timestamp
DROP FUNCTION IF EXISTS timestampIn;
DROP FUNCTION
CREATE FUNCTION timestampIn(timestamp) RETURNS timestamp
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT timestampIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:675: ERROR:  function timestampin(smallint) does not exist
LINE 1: SELECT timestampIn(shortVal) FROM srcTestTable WHERE shortVa...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:676: ERROR:  function timestampin(integer) does not exist
LINE 1: SELECT timestampIn(intVal) FROM srcTestTable WHERE intVal = ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:677: ERROR:  function timestampin(bigint) does not exist
LINE 1: SELECT timestampIn(longVal) FROM srcTestTable WHERE longVal ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:678: ERROR:  function timestampin(double precision) does not exist
LINE 1: SELECT timestampIn(doubleVal) FROM srcTestTable WHERE double...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:679: ERROR:  function timestampin(real) does not exist
LINE 1: SELECT timestampIn(floatVal) FROM srcTestTable WHERE floatVa...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:680: ERROR:  function timestampin(numeric) does not exist
LINE 1: SELECT timestampIn(decimal3_0Val) FROM srcTestTable WHERE de...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:681: ERROR:  function timestampin(numeric) does not exist
LINE 1: SELECT timestampIn(decimal5_0Val) FROM srcTestTable WHERE de...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:682: ERROR:  function timestampin(numeric) does not exist
LINE 1: SELECT timestampIn(decimal10_0Val) FROM srcTestTable WHERE d...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:683: ERROR:  function timestampin(numeric) does not exist
LINE 1: SELECT timestampIn(decimal10_2Val) FROM srcTestTable WHERE d...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:684: ERROR:  function timestampin(numeric) does not exist
LINE 1: SELECT timestampIn(decimal30_15Val) FROM srcTestTable WHERE ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:685: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT timestampIn(decimal14_7In) FROM srcTestTable WHERE de...
                           ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT timestampIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:686: ERROR:  function timestampin(bytea) does not exist
LINE 1: SELECT timestampIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:687: ERROR:  function timestampin(boolean) does not exist
LINE 1: SELECT timestampIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:688: ERROR:  function timestampin(text) does not exist
LINE 1: SELECT timestampIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(dateVal) FROM srcTestTable LIMIT 1;
     timestampin
---------------------
 1970-01-01 00:00:00
(1 row)

SELECT timestampIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:690: ERROR:  function timestampin(integer[]) does not exist
LINE 1: SELECT timestampIn(arrayIntVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:691: ERROR:  function timestampin(double precision[]) does not exist
LINE 1: SELECT timestampIn(arrayDoubleVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:692: ERROR:  function timestampin(structintdoublety) does not exist
LINE 1: SELECT timestampIn(structIntDoubleVal) FROM srcTestTable LIM...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:693: ERROR:  function timestampin(structstringintty) does not exist
LINE 1: SELECT timestampIn(structStringIntVal) FROM srcTestTable LIM...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT timestampIn(null);
 timestampin
-------------
 NULL
(1 row)

-- from * to int[]
DROP FUNCTION IF EXISTS arrayIntIn;
DROP FUNCTION
CREATE FUNCTION arrayIntIn(int[]) RETURNS int[]
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT arrayIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:704: ERROR:  function arrayintin(smallint) does not exist
LINE 1: SELECT arrayIntIn(shortVal) FROM srcTestTable WHERE shortVal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:705: ERROR:  function arrayintin(integer) does not exist
LINE 1: SELECT arrayIntIn(intVal) FROM srcTestTable WHERE intVal = 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:706: ERROR:  function arrayintin(bigint) does not exist
LINE 1: SELECT arrayIntIn(longVal) FROM srcTestTable WHERE longVal =...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:707: ERROR:  function arrayintin(double precision) does not exist
LINE 1: SELECT arrayIntIn(doubleVal) FROM srcTestTable WHERE doubleV...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:708: ERROR:  function arrayintin(real) does not exist
LINE 1: SELECT arrayIntIn(floatVal) FROM srcTestTable WHERE floatVal...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:709: ERROR:  function arrayintin(numeric) does not exist
LINE 1: SELECT arrayIntIn(decimal3_0Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:710: ERROR:  function arrayintin(numeric) does not exist
LINE 1: SELECT arrayIntIn(decimal5_0Val) FROM srcTestTable WHERE dec...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:711: ERROR:  function arrayintin(numeric) does not exist
LINE 1: SELECT arrayIntIn(decimal10_0Val) FROM srcTestTable WHERE de...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:712: ERROR:  function arrayintin(numeric) does not exist
LINE 1: SELECT arrayIntIn(decimal10_2Val) FROM srcTestTable WHERE de...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:713: ERROR:  function arrayintin(numeric) does not exist
LINE 1: SELECT arrayIntIn(decimal30_15Val) FROM srcTestTable WHERE d...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:714: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT arrayIntIn(decimal14_7In) FROM srcTestTable WHERE dec...
                          ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT arrayIntIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:715: ERROR:  function arrayintin(bytea) does not exist
LINE 1: SELECT arrayIntIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:716: ERROR:  function arrayintin(boolean) does not exist
LINE 1: SELECT arrayIntIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:717: ERROR:  function arrayintin(text) does not exist
LINE 1: SELECT arrayIntIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:718: ERROR:  function arrayintin(date) does not exist
LINE 1: SELECT arrayIntIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:719: ERROR:  function arrayintin(timestamp without time zone) does not exist
LINE 1: SELECT arrayIntIn(timestampVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:720: ERROR:  function arrayintin(double precision[]) does not exist
LINE 1: SELECT arrayIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:721: ERROR:  function arrayintin(structintdoublety) does not exist
LINE 1: SELECT arrayIntIn(structIntDoubleVal) FROM srcTestTable LIMI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:722: ERROR:  function arrayintin(structstringintty) does not exist
LINE 1: SELECT arrayIntIn(structStringIntVal) FROM srcTestTable LIMI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayIntIn(null);
 arrayintin
------------
 NULL
(1 row)

-- from * to float8[]
DROP FUNCTION IF EXISTS arrayDoubleIn;
DROP FUNCTION
CREATE FUNCTION arrayDoubleIn(float8[]) RETURNS float8[]
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT arrayDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:733: ERROR:  function arraydoublein(smallint) does not exist
LINE 1: SELECT arrayDoubleIn(shortVal) FROM srcTestTable WHERE short...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:734: ERROR:  function arraydoublein(integer) does not exist
LINE 1: SELECT arrayDoubleIn(intVal) FROM srcTestTable WHERE intVal ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:735: ERROR:  function arraydoublein(bigint) does not exist
LINE 1: SELECT arrayDoubleIn(longVal) FROM srcTestTable WHERE longVa...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:736: ERROR:  function arraydoublein(double precision) does not exist
LINE 1: SELECT arrayDoubleIn(doubleVal) FROM srcTestTable WHERE doub...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:737: ERROR:  function arraydoublein(real) does not exist
LINE 1: SELECT arrayDoubleIn(floatVal) FROM srcTestTable WHERE float...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:738: ERROR:  function arraydoublein(numeric) does not exist
LINE 1: SELECT arrayDoubleIn(decimal3_0Val) FROM srcTestTable WHERE ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:739: ERROR:  function arraydoublein(numeric) does not exist
LINE 1: SELECT arrayDoubleIn(decimal5_0Val) FROM srcTestTable WHERE ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:740: ERROR:  function arraydoublein(numeric) does not exist
LINE 1: SELECT arrayDoubleIn(decimal10_0Val) FROM srcTestTable WHERE...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:741: ERROR:  function arraydoublein(numeric) does not exist
LINE 1: SELECT arrayDoubleIn(decimal10_2Val) FROM srcTestTable WHERE...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:742: ERROR:  function arraydoublein(numeric) does not exist
LINE 1: SELECT arrayDoubleIn(decimal30_15Val) FROM srcTestTable WHER...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:743: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT arrayDoubleIn(decimal14_7In) FROM srcTestTable WHERE ...
                             ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT arrayDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:744: ERROR:  function arraydoublein(bytea) does not exist
LINE 1: SELECT arrayDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:745: ERROR:  function arraydoublein(boolean) does not exist
LINE 1: SELECT arrayDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:746: ERROR:  function arraydoublein(text) does not exist
LINE 1: SELECT arrayDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:747: ERROR:  function arraydoublein(date) does not exist
LINE 1: SELECT arrayDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:748: ERROR:  function arraydoublein(timestamp without time zone) does not exist
LINE 1: SELECT arrayDoubleIn(timestampVal) FROM srcTestTable LIMIT 1...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
 arraydoublein
---------------
 {1,2,3}
(1 row)

SELECT arrayDoubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:750: ERROR:  function arraydoublein(structintdoublety) does not exist
LINE 1: SELECT arrayDoubleIn(structIntDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:751: ERROR:  function arraydoublein(structstringintty) does not exist
LINE 1: SELECT arrayDoubleIn(structStringIntVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT arrayDoubleIn(null);
 arraydoublein
---------------
 NULL
(1 row)

-- from * to structIntDoubleTy
DROP FUNCTION IF EXISTS structIntDoubleIn;
DROP FUNCTION
CREATE FUNCTION structIntDoubleIn(structIntDoubleTy) RETURNS structIntDoubleTy
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT structIntDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:762: ERROR:  function structintdoublein(smallint) does not exist
LINE 1: SELECT structIntDoubleIn(shortVal) FROM srcTestTable WHERE s...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:763: ERROR:  function structintdoublein(integer) does not exist
LINE 1: SELECT structIntDoubleIn(intVal) FROM srcTestTable WHERE int...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:764: ERROR:  function structintdoublein(bigint) does not exist
LINE 1: SELECT structIntDoubleIn(longVal) FROM srcTestTable WHERE lo...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:765: ERROR:  function structintdoublein(double precision) does not exist
LINE 1: SELECT structIntDoubleIn(doubleVal) FROM srcTestTable WHERE ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:766: ERROR:  function structintdoublein(real) does not exist
LINE 1: SELECT structIntDoubleIn(floatVal) FROM srcTestTable WHERE f...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:767: ERROR:  function structintdoublein(numeric) does not exist
LINE 1: SELECT structIntDoubleIn(decimal3_0Val) FROM srcTestTable WH...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:768: ERROR:  function structintdoublein(numeric) does not exist
LINE 1: SELECT structIntDoubleIn(decimal5_0Val) FROM srcTestTable WH...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:769: ERROR:  function structintdoublein(numeric) does not exist
LINE 1: SELECT structIntDoubleIn(decimal10_0Val) FROM srcTestTable W...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:770: ERROR:  function structintdoublein(numeric) does not exist
LINE 1: SELECT structIntDoubleIn(decimal10_2Val) FROM srcTestTable W...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:771: ERROR:  function structintdoublein(numeric) does not exist
LINE 1: SELECT structIntDoubleIn(decimal30_15Val) FROM srcTestTable ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:772: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT structIntDoubleIn(decimal14_7In) FROM srcTestTable WH...
                                 ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT structIntDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:773: ERROR:  function structintdoublein(bytea) does not exist
LINE 1: SELECT structIntDoubleIn(binaryVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:774: ERROR:  function structintdoublein(boolean) does not exist
LINE 1: SELECT structIntDoubleIn(booleanVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:775: ERROR:  function structintdoublein(text) does not exist
LINE 1: SELECT structIntDoubleIn(stringVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:776: ERROR:  function structintdoublein(date) does not exist
LINE 1: SELECT structIntDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:777: ERROR:  function structintdoublein(timestamp without time zone) does not exist
LINE 1: SELECT structIntDoubleIn(timestampVal) FROM srcTestTable LIM...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:778: ERROR:  function structintdoublein(integer[]) does not exist
LINE 1: SELECT structIntDoubleIn(arrayIntVal) FROM srcTestTable LIMI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:779: ERROR:  function structintdoublein(double precision[]) does not exist
LINE 1: SELECT structIntDoubleIn(arrayDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:780: ERROR:  function structintdoublein(structstringintty) does not exist
LINE 1: SELECT structIntDoubleIn(structStringIntVal) FROM srcTestTab...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structIntDoubleIn(null);
 structintdoublein
-------------------
 NULL
(1 row)

-- from * to structStringIntTy
DROP FUNCTION IF EXISTS structStringIntIn;
DROP FUNCTION
CREATE FUNCTION structStringIntIn(structStringIntTy) RETURNS structStringIntTy
  AS 'select $1;'
  LANGUAGE SQL
  IMMUTABLE
  RETURNS NULL ON NULL INPUT;
CREATE FUNCTION
SELECT structStringIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
psql:implicitCasts.sql:791: ERROR:  function structstringintin(smallint) does not exist
LINE 1: SELECT structStringIntIn(shortVal) FROM srcTestTable WHERE s...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
psql:implicitCasts.sql:792: ERROR:  function structstringintin(integer) does not exist
LINE 1: SELECT structStringIntIn(intVal) FROM srcTestTable WHERE int...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
psql:implicitCasts.sql:793: ERROR:  function structstringintin(bigint) does not exist
LINE 1: SELECT structStringIntIn(longVal) FROM srcTestTable WHERE lo...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
psql:implicitCasts.sql:794: ERROR:  function structstringintin(double precision) does not exist
LINE 1: SELECT structStringIntIn(doubleVal) FROM srcTestTable WHERE ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
psql:implicitCasts.sql:795: ERROR:  function structstringintin(real) does not exist
LINE 1: SELECT structStringIntIn(floatVal) FROM srcTestTable WHERE f...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
psql:implicitCasts.sql:796: ERROR:  function structstringintin(numeric) does not exist
LINE 1: SELECT structStringIntIn(decimal3_0Val) FROM srcTestTable WH...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
psql:implicitCasts.sql:797: ERROR:  function structstringintin(numeric) does not exist
LINE 1: SELECT structStringIntIn(decimal5_0Val) FROM srcTestTable WH...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
psql:implicitCasts.sql:798: ERROR:  function structstringintin(numeric) does not exist
LINE 1: SELECT structStringIntIn(decimal10_0Val) FROM srcTestTable W...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
psql:implicitCasts.sql:799: ERROR:  function structstringintin(numeric) does not exist
LINE 1: SELECT structStringIntIn(decimal10_2Val) FROM srcTestTable W...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:800: ERROR:  function structstringintin(numeric) does not exist
LINE 1: SELECT structStringIntIn(decimal30_15Val) FROM srcTestTable ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
psql:implicitCasts.sql:801: ERROR:  column "decimal14_7in" does not exist
LINE 1: SELECT structStringIntIn(decimal14_7In) FROM srcTestTable WH...
                                 ^
HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
SELECT structStringIntIn(binaryVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:802: ERROR:  function structstringintin(bytea) does not exist
LINE 1: SELECT structStringIntIn(binaryVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(booleanVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:803: ERROR:  function structstringintin(boolean) does not exist
LINE 1: SELECT structStringIntIn(booleanVal) FROM srcTestTable LIMIT...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(stringVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:804: ERROR:  function structstringintin(text) does not exist
LINE 1: SELECT structStringIntIn(stringVal) FROM srcTestTable LIMIT ...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(dateVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:805: ERROR:  function structstringintin(date) does not exist
LINE 1: SELECT structStringIntIn(dateVal) FROM srcTestTable LIMIT 1;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(timestampVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:806: ERROR:  function structstringintin(timestamp without time zone) does not exist
LINE 1: SELECT structStringIntIn(timestampVal) FROM srcTestTable LIM...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(arrayIntVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:807: ERROR:  function structstringintin(integer[]) does not exist
LINE 1: SELECT structStringIntIn(arrayIntVal) FROM srcTestTable LIMI...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:808: ERROR:  function structstringintin(double precision[]) does not exist
LINE 1: SELECT structStringIntIn(arrayDoubleVal) FROM srcTestTable L...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
psql:implicitCasts.sql:809: ERROR:  function structstringintin(structintdoublety) does not exist
LINE 1: SELECT structStringIntIn(structIntDoubleVal) FROM srcTestTab...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT structStringIntIn(null);
 structstringintin
-------------------
 NULL
(1 row)