DXgJWjEW

1-- psql -d postgres -a -f implicitCasts.sql > result.log 2>&1
2\pset null 'NULL'
3Null display is "NULL".
4DROP TYPE IF EXISTS structIntDoubleTy;
5psql:implicitCasts.sql:4: ERROR:  cannot drop type structintdoublety because other objects depend on it
6DETAIL:  column structintdoubleval of table dststructintdoublevaltable depends on type structintdoublety
7column structintdoubleval of table srctesttable depends on type structintdoublety
8function structintdoublein(structintdoublety) depends on type structintdoublety
9HINT:  Use DROP ... CASCADE to drop the dependent objects too.
10DROP TYPE IF EXISTS structStringIntTy;
11psql:implicitCasts.sql:5: ERROR:  cannot drop type structstringintty because other objects depend on it
12DETAIL:  column structstringintval of table dststructstringintvaltable depends on type structstringintty
13column structstringintval of table srctesttable depends on type structstringintty
14function structstringintin(structstringintty) depends on type structstringintty
15HINT:  Use DROP ... CASCADE to drop the dependent objects too.
16CREATE TYPE structIntDoubleTy AS (
17  d0 int,
18  d1 float8
19);
20psql:implicitCasts.sql:10: ERROR:  type "structintdoublety" already exists
21CREATE TYPE structStringIntTy AS (
22  d0 text,
23  d1 int
24);
25psql:implicitCasts.sql:15: ERROR:  type "structstringintty" already exists
26DROP TABLE IF EXISTS srcTestTable;
27DROP TABLE
28CREATE TABLE srcTestTable(
29  shortVal smallint,
30  intVal int,
31  longVal bigint,
32  doubleVal float8,
33  floatVal float4,
34  decimal3_0Val decimal(3, 0),
35  decimal5_0Val decimal(5, 0),
36  decimal10_0Val decimal(10, 0),
37  decimal10_2Val decimal(10, 2),
38  decimal20_0Val decimal(20, 0),
39  decimal30_15Val decimal(30, 15),
40  decimal14_7Val decimal(14, 7),
41  binaryVal bytea,
42  booleanVal boolean,
43  stringVal text,
44  dateVal date,
45  timestampVal timestamp,
46  arrayIntVal int[],
47  arrayDoubleVal float8[],
48  structIntDoubleVal structIntDoubleTy,
49  structStringIntVal structStringIntTy
50);
51CREATE TABLE
52INSERT INTO srcTestTable VALUES(
53  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',
54  '{1, 2, 3}', '{1.0, 2.0, 3.0}', ROW(1, 1.0), ROW('a', 1)
55);
56INSERT 0 1
57INSERT INTO srcTestTable VALUES(
58  32767, 2147483647, 9223372036854775807, 1.797693e+308, 3.402823e+38,
59  999, 99999, 9999999999, 99999.99, 9999999999999999999, 999999999999999.999999999999999, 9999999.9999999,
60  'def', false, 'def', '2018-07-06', '2018-07-06 00:00:00',
61  '{4, 5, 6}', '{4.0, 5.0, 6.0}', ROW(2, 2.0), ROW('b', 2)
62);
63INSERT 0 1
64SELECT * FROM srcTestTable;
65 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 
66----------+------------+---------------------+---------------+-------------+---------------+---------------+----------------+----------------+---------------------+---------------------------------+-----------------+-----------+------------+-----------+------------+---------------------+-------------+----------------+--------------------+--------------------
67        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)
68    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)
69(2 rows)
70
71-- binary arithmetic expression cases
72-- (short, *)
73SELECT pg_typeof(shortVal * intVal) FROM srcTestTable WHERE shortVal = 1;
74 pg_typeof 
75-----------
76 integer
77(1 row)
78
79SELECT pg_typeof(shortVal * longVal) FROM srcTestTable WHERE shortVal = 1;
80 pg_typeof 
81-----------
82 bigint
83(1 row)
84
85SELECT pg_typeof(shortVal * doubleVal) FROM srcTestTable WHERE shortVal = 1;
86    pg_typeof     
87------------------
88 double precision
89(1 row)
90
91SELECT pg_typeof(shortVal * floatVal) FROM srcTestTable WHERE shortVal = 1;
92    pg_typeof     
93------------------
94 double precision
95(1 row)
96
97SELECT pg_typeof(shortVal * decimal3_0Val) FROM srcTestTable WHERE shortVal = 1;
98 pg_typeof 
99-----------
100 numeric
101(1 row)
102
103SELECT pg_typeof(shortVal * decimal5_0Val) FROM srcTestTable WHERE shortVal = 1;
104 pg_typeof 
105-----------
106 numeric
107(1 row)
108
109SELECT pg_typeof(shortVal * decimal10_0Val) FROM srcTestTable WHERE shortVal = 1;
110 pg_typeof 
111-----------
112 numeric
113(1 row)
114
115SELECT pg_typeof(shortVal * decimal10_2Val) FROM srcTestTable WHERE shortVal = 1;
116 pg_typeof 
117-----------
118 numeric
119(1 row)
120
121SELECT pg_typeof(shortVal * decimal20_0Val) FROM srcTestTable WHERE shortVal = 1;
122 pg_typeof 
123-----------
124 numeric
125(1 row)
126
127SELECT pg_typeof(shortVal * decimal30_15Val) FROM srcTestTable WHERE shortVal = 1;
128 pg_typeof 
129-----------
130 numeric
131(1 row)
132
133SELECT pg_typeof(shortVal * decimal14_7Val) FROM srcTestTable WHERE shortVal = 1;
134 pg_typeof 
135-----------
136 numeric
137(1 row)
138
139-- (int, *)
140SELECT pg_typeof(intVal * longVal) FROM srcTestTable WHERE intVal = 1;
141 pg_typeof 
142-----------
143 bigint
144(1 row)
145
146SELECT pg_typeof(intVal * doubleVal) FROM srcTestTable WHERE intVal = 1;
147    pg_typeof     
148------------------
149 double precision
150(1 row)
151
152SELECT pg_typeof(intVal * floatVal) FROM srcTestTable WHERE intVal = 1;
153    pg_typeof     
154------------------
155 double precision
156(1 row)
157
158SELECT pg_typeof(intVal * decimal3_0Val) FROM srcTestTable WHERE intVal = 1;
159 pg_typeof 
160-----------
161 numeric
162(1 row)
163
164SELECT pg_typeof(intVal * decimal5_0Val) FROM srcTestTable WHERE intVal = 1;
165 pg_typeof 
166-----------
167 numeric
168(1 row)
169
170SELECT pg_typeof(intVal * decimal10_0Val) FROM srcTestTable WHERE intVal = 1;
171 pg_typeof 
172-----------
173 numeric
174(1 row)
175
176SELECT pg_typeof(intVal * decimal10_2Val) FROM srcTestTable WHERE intVal = 1;
177 pg_typeof 
178-----------
179 numeric
180(1 row)
181
182SELECT pg_typeof(intVal * decimal20_0Val) FROM srcTestTable WHERE intVal = 1;
183 pg_typeof 
184-----------
185 numeric
186(1 row)
187
188SELECT pg_typeof(intVal * decimal30_15Val) FROM srcTestTable WHERE intVal = 1;
189 pg_typeof 
190-----------
191 numeric
192(1 row)
193
194SELECT pg_typeof(intVal * decimal14_7Val) FROM srcTestTable WHERE intVal = 1;
195 pg_typeof 
196-----------
197 numeric
198(1 row)
199
200-- (long, *)
201SELECT pg_typeof(longVal * doubleVal) FROM srcTestTable WHERE longVal = 1;
202    pg_typeof     
203------------------
204 double precision
205(1 row)
206
207SELECT pg_typeof(longVal * floatVal) FROM srcTestTable WHERE longVal = 1;
208    pg_typeof     
209------------------
210 double precision
211(1 row)
212
213SELECT pg_typeof(longVal * decimal3_0Val) FROM srcTestTable WHERE longVal = 1;
214 pg_typeof 
215-----------
216 numeric
217(1 row)
218
219SELECT pg_typeof(longVal * decimal5_0Val) FROM srcTestTable WHERE longVal = 1;
220 pg_typeof 
221-----------
222 numeric
223(1 row)
224
225SELECT pg_typeof(longVal * decimal10_0Val) FROM srcTestTable WHERE longVal = 1;
226 pg_typeof 
227-----------
228 numeric
229(1 row)
230
231SELECT pg_typeof(longVal * decimal10_2Val) FROM srcTestTable WHERE longVal = 1;
232 pg_typeof 
233-----------
234 numeric
235(1 row)
236
237SELECT pg_typeof(longVal * decimal20_0Val) FROM srcTestTable WHERE longVal = 1;
238 pg_typeof 
239-----------
240 numeric
241(1 row)
242
243SELECT pg_typeof(longVal * decimal30_15Val) FROM srcTestTable WHERE longVal = 1;
244 pg_typeof 
245-----------
246 numeric
247(1 row)
248
249SELECT pg_typeof(longVal * decimal14_7Val) FROM srcTestTable WHERE longVal = 1;
250 pg_typeof 
251-----------
252 numeric
253(1 row)
254
255-- (double, *)
256SELECT pg_typeof(doubleVal * floatVal) FROM srcTestTable WHERE doubleVal < 1.1;
257    pg_typeof     
258------------------
259 double precision
260(1 row)
261
262SELECT pg_typeof(doubleVal * decimal3_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
263    pg_typeof     
264------------------
265 double precision
266(1 row)
267
268SELECT pg_typeof(doubleVal * decimal5_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
269    pg_typeof     
270------------------
271 double precision
272(1 row)
273
274SELECT pg_typeof(doubleVal * decimal10_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
275    pg_typeof     
276------------------
277 double precision
278(1 row)
279
280SELECT pg_typeof(doubleVal * decimal10_2Val) FROM srcTestTable WHERE doubleVal < 1.1;
281    pg_typeof     
282------------------
283 double precision
284(1 row)
285
286SELECT pg_typeof(doubleVal * decimal20_0Val) FROM srcTestTable WHERE doubleVal < 1.1;
287    pg_typeof     
288------------------
289 double precision
290(1 row)
291
292SELECT pg_typeof(doubleVal * decimal30_15Val) FROM srcTestTable WHERE doubleVal < 1.1;
293    pg_typeof     
294------------------
295 double precision
296(1 row)
297
298SELECT pg_typeof(doubleVal * decimal14_7Val) FROM srcTestTable WHERE doubleVal < 1.1;
299    pg_typeof     
300------------------
301 double precision
302(1 row)
303
304-- (float, *)
305SELECT pg_typeof(floatVal * decimal3_0Val) FROM srcTestTable WHERE floatVal < 1.1;
306    pg_typeof     
307------------------
308 double precision
309(1 row)
310
311SELECT pg_typeof(floatVal * decimal5_0Val) FROM srcTestTable WHERE floatVal < 1.1;
312    pg_typeof     
313------------------
314 double precision
315(1 row)
316
317SELECT pg_typeof(floatVal * decimal10_0Val) FROM srcTestTable WHERE floatVal < 1.1;
318    pg_typeof     
319------------------
320 double precision
321(1 row)
322
323SELECT pg_typeof(floatVal * decimal10_2Val) FROM srcTestTable WHERE floatVal < 1.1;
324    pg_typeof     
325------------------
326 double precision
327(1 row)
328
329SELECT pg_typeof(floatVal * decimal20_0Val) FROM srcTestTable WHERE floatVal < 1.1;
330    pg_typeof     
331------------------
332 double precision
333(1 row)
334
335SELECT pg_typeof(floatVal * decimal30_15Val) FROM srcTestTable WHERE floatVal < 1.1;
336    pg_typeof     
337------------------
338 double precision
339(1 row)
340
341SELECT pg_typeof(floatVal * decimal14_7Val) FROM srcTestTable WHERE floatVal < 1.1;
342    pg_typeof     
343------------------
344 double precision
345(1 row)
346
347-- (decimal(3, 0), *)
348SELECT pg_typeof(decimal3_0Val * decimal5_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
349 pg_typeof 
350-----------
351 numeric
352(1 row)
353
354SELECT pg_typeof(decimal3_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
355 pg_typeof 
356-----------
357 numeric
358(1 row)
359
360SELECT pg_typeof(decimal3_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal3_0Val = 1;
361 pg_typeof 
362-----------
363 numeric
364(1 row)
365
366SELECT pg_typeof(decimal3_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
367 pg_typeof 
368-----------
369 numeric
370(1 row)
371
372SELECT pg_typeof(decimal3_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal3_0Val = 1;
373 pg_typeof 
374-----------
375 numeric
376(1 row)
377
378SELECT pg_typeof(decimal3_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal3_0Val = 1;
379 pg_typeof 
380-----------
381 numeric
382(1 row)
383
384-- (decimal(5, 0), *)
385SELECT pg_typeof(decimal5_0Val * decimal10_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
386 pg_typeof 
387-----------
388 numeric
389(1 row)
390
391SELECT pg_typeof(decimal5_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal5_0Val = 1;
392 pg_typeof 
393-----------
394 numeric
395(1 row)
396
397SELECT pg_typeof(decimal5_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
398 pg_typeof 
399-----------
400 numeric
401(1 row)
402
403SELECT pg_typeof(decimal5_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal5_0Val = 1;
404 pg_typeof 
405-----------
406 numeric
407(1 row)
408
409SELECT pg_typeof(decimal5_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal5_0Val = 1;
410 pg_typeof 
411-----------
412 numeric
413(1 row)
414
415-- (decimal(10, 0), *)
416SELECT pg_typeof(decimal10_0Val * decimal10_2Val) FROM srcTestTable WHERE decimal10_0Val = 1;
417 pg_typeof 
418-----------
419 numeric
420(1 row)
421
422SELECT pg_typeof(decimal10_0Val * decimal20_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
423 pg_typeof 
424-----------
425 numeric
426(1 row)
427
428SELECT pg_typeof(decimal10_0Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_0Val = 1;
429 pg_typeof 
430-----------
431 numeric
432(1 row)
433
434SELECT pg_typeof(decimal10_0Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_0Val = 1;
435 pg_typeof 
436-----------
437 numeric
438(1 row)
439
440-- (decimal(10, 2), *)
441SELECT pg_typeof(decimal10_2Val * decimal20_0Val) FROM srcTestTable WHERE decimal10_2Val = 1;
442 pg_typeof 
443-----------
444 numeric
445(1 row)
446
447SELECT pg_typeof(decimal10_2Val * decimal30_15Val) FROM srcTestTable WHERE decimal10_2Val = 1;
448 pg_typeof 
449-----------
450 numeric
451(1 row)
452
453SELECT pg_typeof(decimal10_2Val * decimal14_7Val) FROM srcTestTable WHERE decimal10_2Val = 1;
454 pg_typeof 
455-----------
456 numeric
457(1 row)
458
459-- (decimal(30, 15), *)
460SELECT pg_typeof(decimal30_15Val * decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
461 pg_typeof 
462-----------
463 numeric
464(1 row)
465
466SELECT pg_typeof(decimal30_15Val * decimal14_7Val) FROM srcTestTable WHERE decimal30_15Val = 1;
467 pg_typeof 
468-----------
469 numeric
470(1 row)
471
472-- binary arithmetic expression cases
473-- (binary, *)
474SELECT pg_typeof(binaryVal || shortVal) FROM srcTestTable LIMIT 1;
475psql:implicitCasts.sql:147: ERROR:  operator does not exist: bytea || smallint
476LINE 1: SELECT pg_typeof(binaryVal || shortVal) FROM srcTestTable LI...
477                                   ^
478HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
479SELECT pg_typeof(binaryVal || intVal) FROM srcTestTable LIMIT 1;
480psql:implicitCasts.sql:148: ERROR:  operator does not exist: bytea || integer
481LINE 1: SELECT pg_typeof(binaryVal || intVal) FROM srcTestTable LIMI...
482                                   ^
483HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
484SELECT pg_typeof(binaryVal || longVal) FROM srcTestTable LIMIT 1;
485psql:implicitCasts.sql:149: ERROR:  operator does not exist: bytea || bigint
486LINE 1: SELECT pg_typeof(binaryVal || longVal) FROM srcTestTable LIM...
487                                   ^
488HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
489SELECT pg_typeof(binaryVal || doubleVal) FROM srcTestTable LIMIT 1;
490psql:implicitCasts.sql:150: ERROR:  operator does not exist: bytea || double precision
491LINE 1: SELECT pg_typeof(binaryVal || doubleVal) FROM srcTestTable L...
492                                   ^
493HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
494SELECT pg_typeof(binaryVal || floatVal) FROM srcTestTable LIMIT 1;
495psql:implicitCasts.sql:151: ERROR:  operator does not exist: bytea || real
496LINE 1: SELECT pg_typeof(binaryVal || floatVal) FROM srcTestTable LI...
497                                   ^
498HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
499SELECT pg_typeof(binaryVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
500psql:implicitCasts.sql:152: ERROR:  operator does not exist: bytea || numeric
501LINE 1: SELECT pg_typeof(binaryVal || decimal3_0Val) FROM srcTestTab...
502                                   ^
503HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
504SELECT pg_typeof(binaryVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
505psql:implicitCasts.sql:153: ERROR:  operator does not exist: bytea || numeric
506LINE 1: SELECT pg_typeof(binaryVal || decimal5_0Val) FROM srcTestTab...
507                                   ^
508HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
509SELECT pg_typeof(binaryVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
510psql:implicitCasts.sql:154: ERROR:  operator does not exist: bytea || numeric
511LINE 1: SELECT pg_typeof(binaryVal || decimal10_0Val) FROM srcTestTa...
512                                   ^
513HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
514SELECT pg_typeof(binaryVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
515psql:implicitCasts.sql:155: ERROR:  operator does not exist: bytea || numeric
516LINE 1: SELECT pg_typeof(binaryVal || decimal10_2Val) FROM srcTestTa...
517                                   ^
518HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
519SELECT pg_typeof(binaryVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
520psql:implicitCasts.sql:156: ERROR:  operator does not exist: bytea || numeric
521LINE 1: SELECT pg_typeof(binaryVal || decimal20_0Val) FROM srcTestTa...
522                                   ^
523HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
524SELECT pg_typeof(binaryVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
525psql:implicitCasts.sql:157: ERROR:  operator does not exist: bytea || numeric
526LINE 1: SELECT pg_typeof(binaryVal || decimal30_15Val) FROM srcTestT...
527                                   ^
528HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
529SELECT pg_typeof(binaryVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
530psql:implicitCasts.sql:158: ERROR:  operator does not exist: bytea || numeric
531LINE 1: SELECT pg_typeof(binaryVal || decimal14_7Val) FROM srcTestTa...
532                                   ^
533HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
534SELECT pg_typeof(binaryVal || booleanVal) FROM srcTestTable LIMIT 1;
535psql:implicitCasts.sql:159: ERROR:  operator does not exist: bytea || boolean
536LINE 1: SELECT pg_typeof(binaryVal || booleanVal) FROM srcTestTable ...
537                                   ^
538HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
539SELECT pg_typeof(binaryVal || stringVal) FROM srcTestTable LIMIT 1;
540 pg_typeof 
541-----------
542 text
543(1 row)
544
545SELECT pg_typeof(binaryVal || dateVal) FROM srcTestTable LIMIT 1;
546psql:implicitCasts.sql:161: ERROR:  operator does not exist: bytea || date
547LINE 1: SELECT pg_typeof(binaryVal || dateVal) FROM srcTestTable LIM...
548                                   ^
549HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
550SELECT pg_typeof(binaryVal || timestampVal) FROM srcTestTable LIMIT 1;
551psql:implicitCasts.sql:162: ERROR:  operator does not exist: bytea || timestamp without time zone
552LINE 1: SELECT pg_typeof(binaryVal || timestampVal) FROM srcTestTabl...
553                                   ^
554HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
555SELECT pg_typeof(binaryVal || arrayIntVal) FROM srcTestTable LIMIT 1;
556psql:implicitCasts.sql:163: ERROR:  operator does not exist: bytea || integer[]
557LINE 1: SELECT pg_typeof(binaryVal || arrayIntVal) FROM srcTestTable...
558                                   ^
559HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
560SELECT pg_typeof(binaryVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
561psql:implicitCasts.sql:164: ERROR:  operator does not exist: bytea || double precision[]
562LINE 1: SELECT pg_typeof(binaryVal || arrayDoubleVal) FROM srcTestTa...
563                                   ^
564HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
565SELECT pg_typeof(binaryVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
566psql:implicitCasts.sql:165: ERROR:  operator does not exist: bytea || structintdoublety
567LINE 1: SELECT pg_typeof(binaryVal || structIntDoubleVal) FROM srcTe...
568                                   ^
569HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
570SELECT pg_typeof(binaryVal || structStringIntVal) FROM srcTestTable LIMIT 1;
571psql:implicitCasts.sql:166: ERROR:  operator does not exist: bytea || structstringintty
572LINE 1: SELECT pg_typeof(binaryVal || structStringIntVal) FROM srcTe...
573                                   ^
574HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
575-- (text, *)
576SELECT pg_typeof(stringVal || shortVal) FROM srcTestTable LIMIT 1;
577 pg_typeof 
578-----------
579 text
580(1 row)
581
582SELECT pg_typeof(stringVal || intVal) FROM srcTestTable LIMIT 1;
583 pg_typeof 
584-----------
585 text
586(1 row)
587
588SELECT pg_typeof(stringVal || longVal) FROM srcTestTable LIMIT 1;
589 pg_typeof 
590-----------
591 text
592(1 row)
593
594SELECT pg_typeof(stringVal || doubleVal) FROM srcTestTable LIMIT 1;
595 pg_typeof 
596-----------
597 text
598(1 row)
599
600SELECT pg_typeof(stringVal || floatVal) FROM srcTestTable LIMIT 1;
601 pg_typeof 
602-----------
603 text
604(1 row)
605
606SELECT pg_typeof(stringVal || decimal3_0Val) FROM srcTestTable LIMIT 1;
607 pg_typeof 
608-----------
609 text
610(1 row)
611
612SELECT pg_typeof(stringVal || decimal5_0Val) FROM srcTestTable LIMIT 1;
613 pg_typeof 
614-----------
615 text
616(1 row)
617
618SELECT pg_typeof(stringVal || decimal10_0Val) FROM srcTestTable LIMIT 1;
619 pg_typeof 
620-----------
621 text
622(1 row)
623
624SELECT pg_typeof(stringVal || decimal10_2Val) FROM srcTestTable LIMIT 1;
625 pg_typeof 
626-----------
627 text
628(1 row)
629
630SELECT pg_typeof(stringVal || decimal20_0Val) FROM srcTestTable LIMIT 1;
631 pg_typeof 
632-----------
633 text
634(1 row)
635
636SELECT pg_typeof(stringVal || decimal30_15Val) FROM srcTestTable LIMIT 1;
637 pg_typeof 
638-----------
639 text
640(1 row)
641
642SELECT pg_typeof(stringVal || decimal14_7Val) FROM srcTestTable LIMIT 1;
643 pg_typeof 
644-----------
645 text
646(1 row)
647
648SELECT pg_typeof(stringVal || booleanVal) FROM srcTestTable LIMIT 1;
649 pg_typeof 
650-----------
651 text
652(1 row)
653
654SELECT pg_typeof(stringVal || stringVal) FROM srcTestTable LIMIT 1;
655 pg_typeof 
656-----------
657 text
658(1 row)
659
660SELECT pg_typeof(stringVal || dateVal) FROM srcTestTable LIMIT 1;
661 pg_typeof 
662-----------
663 text
664(1 row)
665
666SELECT pg_typeof(stringVal || timestampVal) FROM srcTestTable LIMIT 1;
667 pg_typeof 
668-----------
669 text
670(1 row)
671
672SELECT pg_typeof(stringVal || arrayIntVal) FROM srcTestTable LIMIT 1;
673psql:implicitCasts.sql:185: ERROR:  operator does not exist: text || integer[]
674LINE 1: SELECT pg_typeof(stringVal || arrayIntVal) FROM srcTestTable...
675                                   ^
676HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
677SELECT pg_typeof(stringVal || arrayDoubleVal) FROM srcTestTable LIMIT 1;
678psql:implicitCasts.sql:186: ERROR:  operator does not exist: text || double precision[]
679LINE 1: SELECT pg_typeof(stringVal || arrayDoubleVal) FROM srcTestTa...
680                                   ^
681HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
682SELECT pg_typeof(stringVal || structIntDoubleVal) FROM srcTestTable LIMIT 1;
683 pg_typeof 
684-----------
685 text
686(1 row)
687
688SELECT pg_typeof(stringVal || structStringIntVal) FROM srcTestTable LIMIT 1;
689 pg_typeof 
690-----------
691 text
692(1 row)
693
694-- function inputs
695-- from * to short
696DROP FUNCTION IF EXISTS shortIn;
697DROP FUNCTION
698CREATE FUNCTION shortIn(smallint) RETURNS smallint
699  AS 'select $1;'
700  LANGUAGE SQL
701  IMMUTABLE
702  RETURNS NULL ON NULL INPUT;
703CREATE FUNCTION
704SELECT shortIn(intVal) FROM srcTestTable WHERE intVal = 1;
705psql:implicitCasts.sql:201: ERROR:  function shortin(integer) does not exist
706LINE 1: SELECT shortIn(intVal) FROM srcTestTable WHERE intVal = 1;
707               ^
708HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
709SELECT shortIn(longVal) FROM srcTestTable WHERE longVal = 1;
710psql:implicitCasts.sql:202: ERROR:  function shortin(bigint) does not exist
711LINE 1: SELECT shortIn(longVal) FROM srcTestTable WHERE longVal = 1;
712               ^
713HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
714SELECT shortIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
715psql:implicitCasts.sql:203: ERROR:  function shortin(double precision) does not exist
716LINE 1: SELECT shortIn(doubleVal) FROM srcTestTable WHERE doubleVal ...
717               ^
718HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
719SELECT shortIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
720psql:implicitCasts.sql:204: ERROR:  function shortin(real) does not exist
721LINE 1: SELECT shortIn(floatVal) FROM srcTestTable WHERE floatVal < ...
722               ^
723HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
724SELECT shortIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
725psql:implicitCasts.sql:205: ERROR:  function shortin(numeric) does not exist
726LINE 1: SELECT shortIn(decimal3_0Val) FROM srcTestTable WHERE decima...
727               ^
728HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
729SELECT shortIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
730psql:implicitCasts.sql:206: ERROR:  function shortin(numeric) does not exist
731LINE 1: SELECT shortIn(decimal5_0Val) FROM srcTestTable WHERE decima...
732               ^
733HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
734SELECT shortIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
735psql:implicitCasts.sql:207: ERROR:  function shortin(numeric) does not exist
736LINE 1: SELECT shortIn(decimal10_0Val) FROM srcTestTable WHERE decim...
737               ^
738HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
739SELECT shortIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
740psql:implicitCasts.sql:208: ERROR:  function shortin(numeric) does not exist
741LINE 1: SELECT shortIn(decimal10_2Val) FROM srcTestTable WHERE decim...
742               ^
743HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
744SELECT shortIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
745psql:implicitCasts.sql:209: ERROR:  function shortin(numeric) does not exist
746LINE 1: SELECT shortIn(decimal20_0Val) FROM srcTestTable WHERE decim...
747               ^
748HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
749SELECT shortIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
750psql:implicitCasts.sql:210: ERROR:  function shortin(numeric) does not exist
751LINE 1: SELECT shortIn(decimal30_15Val) FROM srcTestTable WHERE deci...
752               ^
753HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
754SELECT shortIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
755psql:implicitCasts.sql:211: ERROR:  function shortin(numeric) does not exist
756LINE 1: SELECT shortIn(decimal14_7Val) FROM srcTestTable WHERE decim...
757               ^
758HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
759SELECT shortIn(binaryVal) FROM srcTestTable LIMIT 1;
760psql:implicitCasts.sql:212: ERROR:  function shortin(bytea) does not exist
761LINE 1: SELECT shortIn(binaryVal) FROM srcTestTable LIMIT 1;
762               ^
763HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
764SELECT shortIn(booleanVal) FROM srcTestTable LIMIT 1;
765psql:implicitCasts.sql:213: ERROR:  function shortin(boolean) does not exist
766LINE 1: SELECT shortIn(booleanVal) FROM srcTestTable LIMIT 1;
767               ^
768HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
769SELECT shortIn(stringVal) FROM srcTestTable LIMIT 1;
770psql:implicitCasts.sql:214: ERROR:  function shortin(text) does not exist
771LINE 1: SELECT shortIn(stringVal) FROM srcTestTable LIMIT 1;
772               ^
773HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
774SELECT shortIn(dateVal) FROM srcTestTable LIMIT 1;
775psql:implicitCasts.sql:215: ERROR:  function shortin(date) does not exist
776LINE 1: SELECT shortIn(dateVal) FROM srcTestTable LIMIT 1;
777               ^
778HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
779SELECT shortIn(timestampVal) FROM srcTestTable LIMIT 1;
780psql:implicitCasts.sql:216: ERROR:  function shortin(timestamp without time zone) does not exist
781LINE 1: SELECT shortIn(timestampVal) FROM srcTestTable LIMIT 1;
782               ^
783HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
784SELECT shortIn(arrayIntVal) FROM srcTestTable LIMIT 1;
785psql:implicitCasts.sql:217: ERROR:  function shortin(integer[]) does not exist
786LINE 1: SELECT shortIn(arrayIntVal) FROM srcTestTable LIMIT 1;
787               ^
788HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
789SELECT shortIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
790psql:implicitCasts.sql:218: ERROR:  function shortin(double precision[]) does not exist
791LINE 1: SELECT shortIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
792               ^
793HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
794SELECT shortIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
795psql:implicitCasts.sql:219: ERROR:  function shortin(structintdoublety) does not exist
796LINE 1: SELECT shortIn(structIntDoubleVal) FROM srcTestTable LIMIT 1...
797               ^
798HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
799SELECT shortIn(structStringIntVal) FROM srcTestTable LIMIT 1;
800psql:implicitCasts.sql:220: ERROR:  function shortin(structstringintty) does not exist
801LINE 1: SELECT shortIn(structStringIntVal) FROM srcTestTable LIMIT 1...
802               ^
803HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
804SELECT shortIn(null);
805 shortin 
806---------
807    NULL
808(1 row)
809
810-- from * to int
811DROP FUNCTION IF EXISTS intIn;
812DROP FUNCTION
813CREATE FUNCTION intIn(int) RETURNS int
814  AS 'select $1;'
815  LANGUAGE SQL
816  IMMUTABLE
817  RETURNS NULL ON NULL INPUT;
818CREATE FUNCTION
819SELECT intIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
820 intin 
821-------
822     1
823(1 row)
824
825SELECT intIn(longVal) FROM srcTestTable WHERE longVal = 1;
826psql:implicitCasts.sql:232: ERROR:  function intin(bigint) does not exist
827LINE 1: SELECT intIn(longVal) FROM srcTestTable WHERE longVal = 1;
828               ^
829HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
830SELECT intIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
831psql:implicitCasts.sql:233: ERROR:  function intin(double precision) does not exist
832LINE 1: SELECT intIn(doubleVal) FROM srcTestTable WHERE doubleVal < ...
833               ^
834HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
835SELECT intIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
836psql:implicitCasts.sql:234: ERROR:  function intin(real) does not exist
837LINE 1: SELECT intIn(floatVal) FROM srcTestTable WHERE floatVal < 1....
838               ^
839HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
840SELECT intIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
841psql:implicitCasts.sql:235: ERROR:  function intin(numeric) does not exist
842LINE 1: SELECT intIn(decimal3_0Val) FROM srcTestTable WHERE decimal3...
843               ^
844HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
845SELECT intIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
846psql:implicitCasts.sql:236: ERROR:  function intin(numeric) does not exist
847LINE 1: SELECT intIn(decimal5_0Val) FROM srcTestTable WHERE decimal5...
848               ^
849HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
850SELECT intIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
851psql:implicitCasts.sql:237: ERROR:  function intin(numeric) does not exist
852LINE 1: SELECT intIn(decimal10_0Val) FROM srcTestTable WHERE decimal...
853               ^
854HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
855SELECT intIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
856psql:implicitCasts.sql:238: ERROR:  function intin(numeric) does not exist
857LINE 1: SELECT intIn(decimal10_2Val) FROM srcTestTable WHERE decimal...
858               ^
859HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
860SELECT intIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
861psql:implicitCasts.sql:239: ERROR:  function intin(numeric) does not exist
862LINE 1: SELECT intIn(decimal20_0Val) FROM srcTestTable WHERE decimal...
863               ^
864HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
865SELECT intIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
866psql:implicitCasts.sql:240: ERROR:  function intin(numeric) does not exist
867LINE 1: SELECT intIn(decimal30_15Val) FROM srcTestTable WHERE decima...
868               ^
869HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
870SELECT intIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
871psql:implicitCasts.sql:241: ERROR:  function intin(numeric) does not exist
872LINE 1: SELECT intIn(decimal14_7Val) FROM srcTestTable WHERE decimal...
873               ^
874HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
875SELECT intIn(binaryVal) FROM srcTestTable LIMIT 1;
876psql:implicitCasts.sql:242: ERROR:  function intin(bytea) does not exist
877LINE 1: SELECT intIn(binaryVal) FROM srcTestTable LIMIT 1;
878               ^
879HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
880SELECT intIn(booleanVal) FROM srcTestTable LIMIT 1;
881psql:implicitCasts.sql:243: ERROR:  function intin(boolean) does not exist
882LINE 1: SELECT intIn(booleanVal) FROM srcTestTable LIMIT 1;
883               ^
884HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
885SELECT intIn(stringVal) FROM srcTestTable LIMIT 1;
886psql:implicitCasts.sql:244: ERROR:  function intin(text) does not exist
887LINE 1: SELECT intIn(stringVal) FROM srcTestTable LIMIT 1;
888               ^
889HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
890SELECT intIn(dateVal) FROM srcTestTable LIMIT 1;
891psql:implicitCasts.sql:245: ERROR:  function intin(date) does not exist
892LINE 1: SELECT intIn(dateVal) FROM srcTestTable LIMIT 1;
893               ^
894HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
895SELECT intIn(timestampVal) FROM srcTestTable LIMIT 1;
896psql:implicitCasts.sql:246: ERROR:  function intin(timestamp without time zone) does not exist
897LINE 1: SELECT intIn(timestampVal) FROM srcTestTable LIMIT 1;
898               ^
899HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
900SELECT intIn(arrayIntVal) FROM srcTestTable LIMIT 1;
901psql:implicitCasts.sql:247: ERROR:  function intin(integer[]) does not exist
902LINE 1: SELECT intIn(arrayIntVal) FROM srcTestTable LIMIT 1;
903               ^
904HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
905SELECT intIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
906psql:implicitCasts.sql:248: ERROR:  function intin(double precision[]) does not exist
907LINE 1: SELECT intIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
908               ^
909HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
910SELECT intIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
911psql:implicitCasts.sql:249: ERROR:  function intin(structintdoublety) does not exist
912LINE 1: SELECT intIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
913               ^
914HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
915SELECT intIn(structStringIntVal) FROM srcTestTable LIMIT 1;
916psql:implicitCasts.sql:250: ERROR:  function intin(structstringintty) does not exist
917LINE 1: SELECT intIn(structStringIntVal) FROM srcTestTable LIMIT 1;
918               ^
919HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
920SELECT intIn(null);
921 intin 
922-------
923  NULL
924(1 row)
925
926-- from * to long
927DROP FUNCTION IF EXISTS longIn;
928DROP FUNCTION
929CREATE FUNCTION longIn(bigint) RETURNS bigint
930  AS 'select $1;'
931  LANGUAGE SQL
932  IMMUTABLE
933  RETURNS NULL ON NULL INPUT;
934CREATE FUNCTION
935SELECT longIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
936 longin 
937--------
938      1
939(1 row)
940
941SELECT longIn(intVal) FROM srcTestTable WHERE intVal = 1;
942 longin 
943--------
944      1
945(1 row)
946
947SELECT longIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
948psql:implicitCasts.sql:263: ERROR:  function longin(double precision) does not exist
949LINE 1: SELECT longIn(doubleVal) FROM srcTestTable WHERE doubleVal <...
950               ^
951HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
952SELECT longIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
953psql:implicitCasts.sql:264: ERROR:  function longin(real) does not exist
954LINE 1: SELECT longIn(floatVal) FROM srcTestTable WHERE floatVal < 1...
955               ^
956HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
957SELECT longIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
958psql:implicitCasts.sql:265: ERROR:  function longin(numeric) does not exist
959LINE 1: SELECT longIn(decimal3_0Val) FROM srcTestTable WHERE decimal...
960               ^
961HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
962SELECT longIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
963psql:implicitCasts.sql:266: ERROR:  function longin(numeric) does not exist
964LINE 1: SELECT longIn(decimal5_0Val) FROM srcTestTable WHERE decimal...
965               ^
966HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
967SELECT longIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
968psql:implicitCasts.sql:267: ERROR:  function longin(numeric) does not exist
969LINE 1: SELECT longIn(decimal10_0Val) FROM srcTestTable WHERE decima...
970               ^
971HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
972SELECT longIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
973psql:implicitCasts.sql:268: ERROR:  function longin(numeric) does not exist
974LINE 1: SELECT longIn(decimal10_2Val) FROM srcTestTable WHERE decima...
975               ^
976HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
977SELECT longIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
978psql:implicitCasts.sql:269: ERROR:  function longin(numeric) does not exist
979LINE 1: SELECT longIn(decimal20_0Val) FROM srcTestTable WHERE decima...
980               ^
981HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
982SELECT longIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
983psql:implicitCasts.sql:270: ERROR:  function longin(numeric) does not exist
984LINE 1: SELECT longIn(decimal30_15Val) FROM srcTestTable WHERE decim...
985               ^
986HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
987SELECT longIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
988psql:implicitCasts.sql:271: ERROR:  function longin(numeric) does not exist
989LINE 1: SELECT longIn(decimal14_7Val) FROM srcTestTable WHERE decima...
990               ^
991HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
992SELECT longIn(binaryVal) FROM srcTestTable LIMIT 1;
993psql:implicitCasts.sql:272: ERROR:  function longin(bytea) does not exist
994LINE 1: SELECT longIn(binaryVal) FROM srcTestTable LIMIT 1;
995               ^
996HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
997SELECT longIn(booleanVal) FROM srcTestTable LIMIT 1;
998psql:implicitCasts.sql:273: ERROR:  function longin(boolean) does not exist
999LINE 1: SELECT longIn(booleanVal) FROM srcTestTable LIMIT 1;
1000               ^
1001HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1002SELECT longIn(stringVal) FROM srcTestTable LIMIT 1;
1003psql:implicitCasts.sql:274: ERROR:  function longin(text) does not exist
1004LINE 1: SELECT longIn(stringVal) FROM srcTestTable LIMIT 1;
1005               ^
1006HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1007SELECT longIn(dateVal) FROM srcTestTable LIMIT 1;
1008psql:implicitCasts.sql:275: ERROR:  function longin(date) does not exist
1009LINE 1: SELECT longIn(dateVal) FROM srcTestTable LIMIT 1;
1010               ^
1011HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1012SELECT longIn(timestampVal) FROM srcTestTable LIMIT 1;
1013psql:implicitCasts.sql:276: ERROR:  function longin(timestamp without time zone) does not exist
1014LINE 1: SELECT longIn(timestampVal) FROM srcTestTable LIMIT 1;
1015               ^
1016HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1017SELECT longIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1018psql:implicitCasts.sql:277: ERROR:  function longin(integer[]) does not exist
1019LINE 1: SELECT longIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1020               ^
1021HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1022SELECT longIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1023psql:implicitCasts.sql:278: ERROR:  function longin(double precision[]) does not exist
1024LINE 1: SELECT longIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1025               ^
1026HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1027SELECT longIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1028psql:implicitCasts.sql:279: ERROR:  function longin(structintdoublety) does not exist
1029LINE 1: SELECT longIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1030               ^
1031HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1032SELECT longIn(structStringIntVal) FROM srcTestTable LIMIT 1;
1033psql:implicitCasts.sql:280: ERROR:  function longin(structstringintty) does not exist
1034LINE 1: SELECT longIn(structStringIntVal) FROM srcTestTable LIMIT 1;
1035               ^
1036HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1037SELECT longIn(null);
1038 longin 
1039--------
1040   NULL
1041(1 row)
1042
1043-- from * to float8
1044DROP FUNCTION IF EXISTS doubleIn;
1045DROP FUNCTION
1046CREATE FUNCTION doubleIn(float8) RETURNS float8
1047  AS 'select $1;'
1048  LANGUAGE SQL
1049  IMMUTABLE
1050  RETURNS NULL ON NULL INPUT;
1051CREATE FUNCTION
1052SELECT doubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
1053 doublein 
1054----------
1055        1
1056(1 row)
1057
1058SELECT doubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
1059 doublein 
1060----------
1061        1
1062(1 row)
1063
1064SELECT doubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
1065 doublein 
1066----------
1067        1
1068(1 row)
1069
1070SELECT doubleIn(floatVal) FROM srcTestTable WHERE floatVal < 1.1;
1071 doublein 
1072----------
1073        1
1074(1 row)
1075
1076SELECT doubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1077 doublein 
1078----------
1079        1
1080(1 row)
1081
1082SELECT doubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1083 doublein 
1084----------
1085        1
1086(1 row)
1087
1088SELECT doubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1089 doublein 
1090----------
1091        1
1092(1 row)
1093
1094SELECT doubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1095 doublein 
1096----------
1097        1
1098(1 row)
1099
1100SELECT doubleIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1101 doublein 
1102----------
1103        1
1104(1 row)
1105
1106SELECT doubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1107 doublein 
1108----------
1109        1
1110(1 row)
1111
1112SELECT doubleIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1113 doublein 
1114----------
1115        1
1116(1 row)
1117
1118SELECT doubleIn(binaryVal) FROM srcTestTable LIMIT 1;
1119psql:implicitCasts.sql:302: ERROR:  function doublein(bytea) does not exist
1120LINE 1: SELECT doubleIn(binaryVal) FROM srcTestTable LIMIT 1;
1121               ^
1122HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1123SELECT doubleIn(booleanVal) FROM srcTestTable LIMIT 1;
1124psql:implicitCasts.sql:303: ERROR:  function doublein(boolean) does not exist
1125LINE 1: SELECT doubleIn(booleanVal) FROM srcTestTable LIMIT 1;
1126               ^
1127HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1128SELECT doubleIn(stringVal) FROM srcTestTable LIMIT 1;
1129psql:implicitCasts.sql:304: ERROR:  function doublein(text) does not exist
1130LINE 1: SELECT doubleIn(stringVal) FROM srcTestTable LIMIT 1;
1131               ^
1132HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1133SELECT doubleIn(dateVal) FROM srcTestTable LIMIT 1;
1134psql:implicitCasts.sql:305: ERROR:  function doublein(date) does not exist
1135LINE 1: SELECT doubleIn(dateVal) FROM srcTestTable LIMIT 1;
1136               ^
1137HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1138SELECT doubleIn(timestampVal) FROM srcTestTable LIMIT 1;
1139psql:implicitCasts.sql:306: ERROR:  function doublein(timestamp without time zone) does not exist
1140LINE 1: SELECT doubleIn(timestampVal) FROM srcTestTable LIMIT 1;
1141               ^
1142HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1143SELECT doubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1144psql:implicitCasts.sql:307: ERROR:  function doublein(integer[]) does not exist
1145LINE 1: SELECT doubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1146               ^
1147HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1148SELECT doubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1149psql:implicitCasts.sql:308: ERROR:  function doublein(double precision[]) does not exist
1150LINE 1: SELECT doubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1151               ^
1152HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1153SELECT doubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1154psql:implicitCasts.sql:309: ERROR:  function doublein(structintdoublety) does not exist
1155LINE 1: SELECT doubleIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
1156               ^
1157HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1158SELECT doubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
1159psql:implicitCasts.sql:310: ERROR:  function doublein(structstringintty) does not exist
1160LINE 1: SELECT doubleIn(structStringIntVal) FROM srcTestTable LIMIT ...
1161               ^
1162HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1163SELECT doubleIn(null);
1164 doublein 
1165----------
1166     NULL
1167(1 row)
1168
1169-- from * to float4
1170DROP FUNCTION IF EXISTS floatIn;
1171DROP FUNCTION
1172CREATE FUNCTION floatIn(float4) RETURNS float4
1173  AS 'select $1;'
1174  LANGUAGE SQL
1175  IMMUTABLE
1176  RETURNS NULL ON NULL INPUT;
1177CREATE FUNCTION
1178SELECT floatIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
1179 floatin 
1180---------
1181       1
1182(1 row)
1183
1184SELECT floatIn(intVal) FROM srcTestTable WHERE intVal = 1;
1185 floatin 
1186---------
1187       1
1188(1 row)
1189
1190SELECT floatIn(longVal) FROM srcTestTable WHERE longVal = 1;
1191 floatin 
1192---------
1193       1
1194(1 row)
1195
1196SELECT floatIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1197psql:implicitCasts.sql:324: ERROR:  function floatin(double precision) does not exist
1198LINE 1: SELECT floatIn(doubleVal) FROM srcTestTable WHERE doubleVal ...
1199               ^
1200HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1201SELECT floatIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1202 floatin 
1203---------
1204       1
1205(1 row)
1206
1207SELECT floatIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1208 floatin 
1209---------
1210       1
1211(1 row)
1212
1213SELECT floatIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1214 floatin 
1215---------
1216       1
1217(1 row)
1218
1219SELECT floatIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1220 floatin 
1221---------
1222       1
1223(1 row)
1224
1225SELECT floatIn(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1226 floatin 
1227---------
1228       1
1229(1 row)
1230
1231SELECT floatIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1232 floatin 
1233---------
1234       1
1235(1 row)
1236
1237SELECT floatIn(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1238 floatin 
1239---------
1240       1
1241(1 row)
1242
1243SELECT floatIn(binaryVal) FROM srcTestTable LIMIT 1;
1244psql:implicitCasts.sql:332: ERROR:  function floatin(bytea) does not exist
1245LINE 1: SELECT floatIn(binaryVal) FROM srcTestTable LIMIT 1;
1246               ^
1247HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1248SELECT floatIn(booleanVal) FROM srcTestTable LIMIT 1;
1249psql:implicitCasts.sql:333: ERROR:  function floatin(boolean) does not exist
1250LINE 1: SELECT floatIn(booleanVal) FROM srcTestTable LIMIT 1;
1251               ^
1252HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1253SELECT floatIn(stringVal) FROM srcTestTable LIMIT 1;
1254psql:implicitCasts.sql:334: ERROR:  function floatin(text) does not exist
1255LINE 1: SELECT floatIn(stringVal) FROM srcTestTable LIMIT 1;
1256               ^
1257HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1258SELECT floatIn(dateVal) FROM srcTestTable LIMIT 1;
1259psql:implicitCasts.sql:335: ERROR:  function floatin(date) does not exist
1260LINE 1: SELECT floatIn(dateVal) FROM srcTestTable LIMIT 1;
1261               ^
1262HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1263SELECT floatIn(timestampVal) FROM srcTestTable LIMIT 1;
1264psql:implicitCasts.sql:336: ERROR:  function floatin(timestamp without time zone) does not exist
1265LINE 1: SELECT floatIn(timestampVal) FROM srcTestTable LIMIT 1;
1266               ^
1267HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1268SELECT floatIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1269psql:implicitCasts.sql:337: ERROR:  function floatin(integer[]) does not exist
1270LINE 1: SELECT floatIn(arrayIntVal) FROM srcTestTable LIMIT 1;
1271               ^
1272HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1273SELECT floatIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1274psql:implicitCasts.sql:338: ERROR:  function floatin(double precision[]) does not exist
1275LINE 1: SELECT floatIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1276               ^
1277HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1278SELECT floatIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1279psql:implicitCasts.sql:339: ERROR:  function floatin(structintdoublety) does not exist
1280LINE 1: SELECT floatIn(structIntDoubleVal) FROM srcTestTable LIMIT 1...
1281               ^
1282HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1283SELECT floatIn(structStringIntVal) FROM srcTestTable LIMIT 1;
1284psql:implicitCasts.sql:340: ERROR:  function floatin(structstringintty) does not exist
1285LINE 1: SELECT floatIn(structStringIntVal) FROM srcTestTable LIMIT 1...
1286               ^
1287HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1288SELECT floatIn(null);
1289 floatin 
1290---------
1291    NULL
1292(1 row)
1293
1294-- from * to decimal(3, 0)
1295DROP FUNCTION IF EXISTS decimal3_0In;
1296DROP FUNCTION
1297CREATE FUNCTION decimal3_0In(decimal(3, 0)) RETURNS decimal(3, 0)
1298  AS 'select $1;'
1299  LANGUAGE SQL
1300  IMMUTABLE
1301  RETURNS NULL ON NULL INPUT;
1302CREATE FUNCTION
1303SELECT decimal3_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1304 decimal3_0in 
1305--------------
1306            1
1307(1 row)
1308
1309SELECT decimal3_0In(intVal) FROM srcTestTable WHERE intVal = 1;
1310 decimal3_0in 
1311--------------
1312            1
1313(1 row)
1314
1315SELECT decimal3_0In(longVal) FROM srcTestTable WHERE longVal = 1;
1316 decimal3_0in 
1317--------------
1318            1
1319(1 row)
1320
1321SELECT decimal3_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1322psql:implicitCasts.sql:354: ERROR:  function decimal3_0in(double precision) does not exist
1323LINE 1: SELECT decimal3_0In(doubleVal) FROM srcTestTable WHERE doubl...
1324               ^
1325HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1326SELECT decimal3_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1327psql:implicitCasts.sql:355: ERROR:  function decimal3_0in(real) does not exist
1328LINE 1: SELECT decimal3_0In(floatVal) FROM srcTestTable WHERE floatV...
1329               ^
1330HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1331SELECT decimal3_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1332 decimal3_0in 
1333--------------
1334            1
1335(1 row)
1336
1337SELECT decimal3_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1338 decimal3_0in 
1339--------------
1340            1
1341(1 row)
1342
1343SELECT decimal3_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1344 decimal3_0in 
1345--------------
1346         1.00
1347(1 row)
1348
1349SELECT decimal3_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1350 decimal3_0in 
1351--------------
1352            1
1353(1 row)
1354
1355SELECT decimal3_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1356   decimal3_0in    
1357-------------------
1358 1.000000000000000
1359(1 row)
1360
1361SELECT decimal3_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1362 decimal3_0in 
1363--------------
1364    1.0000000
1365(1 row)
1366
1367SELECT decimal3_0In(binaryVal) FROM srcTestTable LIMIT 1;
1368psql:implicitCasts.sql:362: ERROR:  function decimal3_0in(bytea) does not exist
1369LINE 1: SELECT decimal3_0In(binaryVal) FROM srcTestTable LIMIT 1;
1370               ^
1371HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1372SELECT decimal3_0In(booleanVal) FROM srcTestTable LIMIT 1;
1373psql:implicitCasts.sql:363: ERROR:  function decimal3_0in(boolean) does not exist
1374LINE 1: SELECT decimal3_0In(booleanVal) FROM srcTestTable LIMIT 1;
1375               ^
1376HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1377SELECT decimal3_0In(stringVal) FROM srcTestTable LIMIT 1;
1378psql:implicitCasts.sql:364: ERROR:  function decimal3_0in(text) does not exist
1379LINE 1: SELECT decimal3_0In(stringVal) FROM srcTestTable LIMIT 1;
1380               ^
1381HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1382SELECT decimal3_0In(dateVal) FROM srcTestTable LIMIT 1;
1383psql:implicitCasts.sql:365: ERROR:  function decimal3_0in(date) does not exist
1384LINE 1: SELECT decimal3_0In(dateVal) FROM srcTestTable LIMIT 1;
1385               ^
1386HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1387SELECT decimal3_0In(timestampVal) FROM srcTestTable LIMIT 1;
1388psql:implicitCasts.sql:366: ERROR:  function decimal3_0in(timestamp without time zone) does not exist
1389LINE 1: SELECT decimal3_0In(timestampVal) FROM srcTestTable LIMIT 1;
1390               ^
1391HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1392SELECT decimal3_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1393psql:implicitCasts.sql:367: ERROR:  function decimal3_0in(integer[]) does not exist
1394LINE 1: SELECT decimal3_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1395               ^
1396HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1397SELECT decimal3_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1398psql:implicitCasts.sql:368: ERROR:  function decimal3_0in(double precision[]) does not exist
1399LINE 1: SELECT decimal3_0In(arrayDoubleVal) FROM srcTestTable LIMIT ...
1400               ^
1401HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1402SELECT decimal3_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1403psql:implicitCasts.sql:369: ERROR:  function decimal3_0in(structintdoublety) does not exist
1404LINE 1: SELECT decimal3_0In(structIntDoubleVal) FROM srcTestTable LI...
1405               ^
1406HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1407SELECT decimal3_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
1408psql:implicitCasts.sql:370: ERROR:  function decimal3_0in(structstringintty) does not exist
1409LINE 1: SELECT decimal3_0In(structStringIntVal) FROM srcTestTable LI...
1410               ^
1411HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1412SELECT decimal3_0In(null);
1413 decimal3_0in 
1414--------------
1415         NULL
1416(1 row)
1417
1418-- from * to decimal(5, 0)
1419DROP FUNCTION IF EXISTS decimal5_0In;
1420DROP FUNCTION
1421CREATE FUNCTION decimal5_0In(decimal(5, 0)) RETURNS decimal(5, 0)
1422  AS 'select $1;'
1423  LANGUAGE SQL
1424  IMMUTABLE
1425  RETURNS NULL ON NULL INPUT;
1426CREATE FUNCTION
1427SELECT decimal5_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1428 decimal5_0in 
1429--------------
1430            1
1431(1 row)
1432
1433SELECT decimal5_0In(intVal) FROM srcTestTable WHERE intVal = 1;
1434 decimal5_0in 
1435--------------
1436            1
1437(1 row)
1438
1439SELECT decimal5_0In(longVal) FROM srcTestTable WHERE longVal = 1;
1440 decimal5_0in 
1441--------------
1442            1
1443(1 row)
1444
1445SELECT decimal5_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1446psql:implicitCasts.sql:384: ERROR:  function decimal5_0in(double precision) does not exist
1447LINE 1: SELECT decimal5_0In(doubleVal) FROM srcTestTable WHERE doubl...
1448               ^
1449HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1450SELECT decimal5_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1451psql:implicitCasts.sql:385: ERROR:  function decimal5_0in(real) does not exist
1452LINE 1: SELECT decimal5_0In(floatVal) FROM srcTestTable WHERE floatV...
1453               ^
1454HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1455SELECT decimal5_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1456 decimal5_0in 
1457--------------
1458            1
1459(1 row)
1460
1461SELECT decimal5_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1462 decimal5_0in 
1463--------------
1464            1
1465(1 row)
1466
1467SELECT decimal5_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1468 decimal5_0in 
1469--------------
1470         1.00
1471(1 row)
1472
1473SELECT decimal5_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1474 decimal5_0in 
1475--------------
1476            1
1477(1 row)
1478
1479SELECT decimal5_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1480   decimal5_0in    
1481-------------------
1482 1.000000000000000
1483(1 row)
1484
1485SELECT decimal5_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1486 decimal5_0in 
1487--------------
1488    1.0000000
1489(1 row)
1490
1491SELECT decimal5_0In(binaryVal) FROM srcTestTable LIMIT 1;
1492psql:implicitCasts.sql:392: ERROR:  function decimal5_0in(bytea) does not exist
1493LINE 1: SELECT decimal5_0In(binaryVal) FROM srcTestTable LIMIT 1;
1494               ^
1495HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1496SELECT decimal5_0In(booleanVal) FROM srcTestTable LIMIT 1;
1497psql:implicitCasts.sql:393: ERROR:  function decimal5_0in(boolean) does not exist
1498LINE 1: SELECT decimal5_0In(booleanVal) FROM srcTestTable LIMIT 1;
1499               ^
1500HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1501SELECT decimal5_0In(stringVal) FROM srcTestTable LIMIT 1;
1502psql:implicitCasts.sql:394: ERROR:  function decimal5_0in(text) does not exist
1503LINE 1: SELECT decimal5_0In(stringVal) FROM srcTestTable LIMIT 1;
1504               ^
1505HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1506SELECT decimal5_0In(dateVal) FROM srcTestTable LIMIT 1;
1507psql:implicitCasts.sql:395: ERROR:  function decimal5_0in(date) does not exist
1508LINE 1: SELECT decimal5_0In(dateVal) FROM srcTestTable LIMIT 1;
1509               ^
1510HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1511SELECT decimal5_0In(timestampVal) FROM srcTestTable LIMIT 1;
1512psql:implicitCasts.sql:396: ERROR:  function decimal5_0in(timestamp without time zone) does not exist
1513LINE 1: SELECT decimal5_0In(timestampVal) FROM srcTestTable LIMIT 1;
1514               ^
1515HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1516SELECT decimal5_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1517psql:implicitCasts.sql:397: ERROR:  function decimal5_0in(integer[]) does not exist
1518LINE 1: SELECT decimal5_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1519               ^
1520HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1521SELECT decimal5_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1522psql:implicitCasts.sql:398: ERROR:  function decimal5_0in(double precision[]) does not exist
1523LINE 1: SELECT decimal5_0In(arrayDoubleVal) FROM srcTestTable LIMIT ...
1524               ^
1525HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1526SELECT decimal5_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1527psql:implicitCasts.sql:399: ERROR:  function decimal5_0in(structintdoublety) does not exist
1528LINE 1: SELECT decimal5_0In(structIntDoubleVal) FROM srcTestTable LI...
1529               ^
1530HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1531SELECT decimal5_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
1532psql:implicitCasts.sql:400: ERROR:  function decimal5_0in(structstringintty) does not exist
1533LINE 1: SELECT decimal5_0In(structStringIntVal) FROM srcTestTable LI...
1534               ^
1535HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1536SELECT decimal5_0In(null);
1537 decimal5_0in 
1538--------------
1539         NULL
1540(1 row)
1541
1542-- from * to decimal(10, 0)
1543DROP FUNCTION IF EXISTS decimal10_0In;
1544DROP FUNCTION
1545CREATE FUNCTION decimal10_0In(decimal(10, 0)) RETURNS decimal(10, 0)
1546  AS 'select $1;'
1547  LANGUAGE SQL
1548  IMMUTABLE
1549  RETURNS NULL ON NULL INPUT;
1550CREATE FUNCTION
1551SELECT decimal10_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1552 decimal10_0in 
1553---------------
1554             1
1555(1 row)
1556
1557SELECT decimal10_0In(intVal) FROM srcTestTable WHERE intVal = 1;
1558 decimal10_0in 
1559---------------
1560             1
1561(1 row)
1562
1563SELECT decimal10_0In(longVal) FROM srcTestTable WHERE longVal = 1;
1564 decimal10_0in 
1565---------------
1566             1
1567(1 row)
1568
1569SELECT decimal10_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1570psql:implicitCasts.sql:414: ERROR:  function decimal10_0in(double precision) does not exist
1571LINE 1: SELECT decimal10_0In(doubleVal) FROM srcTestTable WHERE doub...
1572               ^
1573HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1574SELECT decimal10_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1575psql:implicitCasts.sql:415: ERROR:  function decimal10_0in(real) does not exist
1576LINE 1: SELECT decimal10_0In(floatVal) FROM srcTestTable WHERE float...
1577               ^
1578HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1579SELECT decimal10_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1580 decimal10_0in 
1581---------------
1582             1
1583(1 row)
1584
1585SELECT decimal10_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1586 decimal10_0in 
1587---------------
1588             1
1589(1 row)
1590
1591SELECT decimal10_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1592 decimal10_0in 
1593---------------
1594          1.00
1595(1 row)
1596
1597SELECT decimal10_0In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1598 decimal10_0in 
1599---------------
1600             1
1601(1 row)
1602
1603SELECT decimal10_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1604   decimal10_0in   
1605-------------------
1606 1.000000000000000
1607(1 row)
1608
1609SELECT decimal10_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1610 decimal10_0in 
1611---------------
1612     1.0000000
1613(1 row)
1614
1615SELECT decimal10_0In(binaryVal) FROM srcTestTable LIMIT 1;
1616psql:implicitCasts.sql:422: ERROR:  function decimal10_0in(bytea) does not exist
1617LINE 1: SELECT decimal10_0In(binaryVal) FROM srcTestTable LIMIT 1;
1618               ^
1619HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1620SELECT decimal10_0In(booleanVal) FROM srcTestTable LIMIT 1;
1621psql:implicitCasts.sql:423: ERROR:  function decimal10_0in(boolean) does not exist
1622LINE 1: SELECT decimal10_0In(booleanVal) FROM srcTestTable LIMIT 1;
1623               ^
1624HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1625SELECT decimal10_0In(stringVal) FROM srcTestTable LIMIT 1;
1626psql:implicitCasts.sql:424: ERROR:  function decimal10_0in(text) does not exist
1627LINE 1: SELECT decimal10_0In(stringVal) FROM srcTestTable LIMIT 1;
1628               ^
1629HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1630SELECT decimal10_0In(dateVal) FROM srcTestTable LIMIT 1;
1631psql:implicitCasts.sql:425: ERROR:  function decimal10_0in(date) does not exist
1632LINE 1: SELECT decimal10_0In(dateVal) FROM srcTestTable LIMIT 1;
1633               ^
1634HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1635SELECT decimal10_0In(timestampVal) FROM srcTestTable LIMIT 1;
1636psql:implicitCasts.sql:426: ERROR:  function decimal10_0in(timestamp without time zone) does not exist
1637LINE 1: SELECT decimal10_0In(timestampVal) FROM srcTestTable LIMIT 1...
1638               ^
1639HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1640SELECT decimal10_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1641psql:implicitCasts.sql:427: ERROR:  function decimal10_0in(integer[]) does not exist
1642LINE 1: SELECT decimal10_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1643               ^
1644HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1645SELECT decimal10_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1646psql:implicitCasts.sql:428: ERROR:  function decimal10_0in(double precision[]) does not exist
1647LINE 1: SELECT decimal10_0In(arrayDoubleVal) FROM srcTestTable LIMIT...
1648               ^
1649HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1650SELECT decimal10_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1651psql:implicitCasts.sql:429: ERROR:  function decimal10_0in(structintdoublety) does not exist
1652LINE 1: SELECT decimal10_0In(structIntDoubleVal) FROM srcTestTable L...
1653               ^
1654HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1655SELECT decimal10_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
1656psql:implicitCasts.sql:430: ERROR:  function decimal10_0in(structstringintty) does not exist
1657LINE 1: SELECT decimal10_0In(structStringIntVal) FROM srcTestTable L...
1658               ^
1659HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1660SELECT decimal10_0In(null);
1661 decimal10_0in 
1662---------------
1663          NULL
1664(1 row)
1665
1666-- from * to decimal(10, 2)
1667DROP FUNCTION IF EXISTS decimal10_2In;
1668DROP FUNCTION
1669CREATE FUNCTION decimal10_2In(decimal(10, 2)) RETURNS decimal(10, 2)
1670  AS 'select $1;'
1671  LANGUAGE SQL
1672  IMMUTABLE
1673  RETURNS NULL ON NULL INPUT;
1674CREATE FUNCTION
1675SELECT decimal10_2In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1676 decimal10_2in 
1677---------------
1678             1
1679(1 row)
1680
1681SELECT decimal10_2In(intVal) FROM srcTestTable WHERE intVal = 1;
1682 decimal10_2in 
1683---------------
1684             1
1685(1 row)
1686
1687SELECT decimal10_2In(longVal) FROM srcTestTable WHERE longVal = 1;
1688 decimal10_2in 
1689---------------
1690             1
1691(1 row)
1692
1693SELECT decimal10_2In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1694psql:implicitCasts.sql:444: ERROR:  function decimal10_2in(double precision) does not exist
1695LINE 1: SELECT decimal10_2In(doubleVal) FROM srcTestTable WHERE doub...
1696               ^
1697HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1698SELECT decimal10_2In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1699psql:implicitCasts.sql:445: ERROR:  function decimal10_2in(real) does not exist
1700LINE 1: SELECT decimal10_2In(floatVal) FROM srcTestTable WHERE float...
1701               ^
1702HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1703SELECT decimal10_2In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1704 decimal10_2in 
1705---------------
1706             1
1707(1 row)
1708
1709SELECT decimal10_2In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1710 decimal10_2in 
1711---------------
1712             1
1713(1 row)
1714
1715SELECT decimal10_2In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1716 decimal10_2in 
1717---------------
1718             1
1719(1 row)
1720
1721SELECT decimal10_2In(decimal20_0Val) FROM srcTestTable WHERE decimal20_0Val = 1;
1722 decimal10_2in 
1723---------------
1724             1
1725(1 row)
1726
1727SELECT decimal10_2In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1728   decimal10_2in   
1729-------------------
1730 1.000000000000000
1731(1 row)
1732
1733SELECT decimal10_2In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1734 decimal10_2in 
1735---------------
1736     1.0000000
1737(1 row)
1738
1739SELECT decimal10_2In(binaryVal) FROM srcTestTable LIMIT 1;
1740psql:implicitCasts.sql:452: ERROR:  function decimal10_2in(bytea) does not exist
1741LINE 1: SELECT decimal10_2In(binaryVal) FROM srcTestTable LIMIT 1;
1742               ^
1743HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1744SELECT decimal10_2In(booleanVal) FROM srcTestTable LIMIT 1;
1745psql:implicitCasts.sql:453: ERROR:  function decimal10_2in(boolean) does not exist
1746LINE 1: SELECT decimal10_2In(booleanVal) FROM srcTestTable LIMIT 1;
1747               ^
1748HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1749SELECT decimal10_2In(stringVal) FROM srcTestTable LIMIT 1;
1750psql:implicitCasts.sql:454: ERROR:  function decimal10_2in(text) does not exist
1751LINE 1: SELECT decimal10_2In(stringVal) FROM srcTestTable LIMIT 1;
1752               ^
1753HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1754SELECT decimal10_2In(dateVal) FROM srcTestTable LIMIT 1;
1755psql:implicitCasts.sql:455: ERROR:  function decimal10_2in(date) does not exist
1756LINE 1: SELECT decimal10_2In(dateVal) FROM srcTestTable LIMIT 1;
1757               ^
1758HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1759SELECT decimal10_2In(timestampVal) FROM srcTestTable LIMIT 1;
1760psql:implicitCasts.sql:456: ERROR:  function decimal10_2in(timestamp without time zone) does not exist
1761LINE 1: SELECT decimal10_2In(timestampVal) FROM srcTestTable LIMIT 1...
1762               ^
1763HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1764SELECT decimal10_2In(arrayIntVal) FROM srcTestTable LIMIT 1;
1765psql:implicitCasts.sql:457: ERROR:  function decimal10_2in(integer[]) does not exist
1766LINE 1: SELECT decimal10_2In(arrayIntVal) FROM srcTestTable LIMIT 1;
1767               ^
1768HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1769SELECT decimal10_2In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1770psql:implicitCasts.sql:458: ERROR:  function decimal10_2in(double precision[]) does not exist
1771LINE 1: SELECT decimal10_2In(arrayDoubleVal) FROM srcTestTable LIMIT...
1772               ^
1773HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1774SELECT decimal10_2In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1775psql:implicitCasts.sql:459: ERROR:  function decimal10_2in(structintdoublety) does not exist
1776LINE 1: SELECT decimal10_2In(structIntDoubleVal) FROM srcTestTable L...
1777               ^
1778HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1779SELECT decimal10_2In(structStringIntVal) FROM srcTestTable LIMIT 1;
1780psql:implicitCasts.sql:460: ERROR:  function decimal10_2in(structstringintty) does not exist
1781LINE 1: SELECT decimal10_2In(structStringIntVal) FROM srcTestTable L...
1782               ^
1783HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1784SELECT decimal10_2In(null);
1785 decimal10_2in 
1786---------------
1787          NULL
1788(1 row)
1789
1790-- from * to decimal(20, 0)
1791DROP FUNCTION IF EXISTS decimal20_0In;
1792DROP FUNCTION
1793CREATE FUNCTION decimal20_0In(decimal(20, 0)) RETURNS decimal(20, 0)
1794  AS 'select $1;'
1795  LANGUAGE SQL
1796  IMMUTABLE
1797  RETURNS NULL ON NULL INPUT;
1798CREATE FUNCTION
1799SELECT decimal20_0In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1800 decimal20_0in 
1801---------------
1802             1
1803(1 row)
1804
1805SELECT decimal20_0In(intVal) FROM srcTestTable WHERE intVal = 1;
1806 decimal20_0in 
1807---------------
1808             1
1809(1 row)
1810
1811SELECT decimal20_0In(longVal) FROM srcTestTable WHERE longVal = 1;
1812 decimal20_0in 
1813---------------
1814             1
1815(1 row)
1816
1817SELECT decimal20_0In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1818psql:implicitCasts.sql:474: ERROR:  function decimal20_0in(double precision) does not exist
1819LINE 1: SELECT decimal20_0In(doubleVal) FROM srcTestTable WHERE doub...
1820               ^
1821HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1822SELECT decimal20_0In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1823psql:implicitCasts.sql:475: ERROR:  function decimal20_0in(real) does not exist
1824LINE 1: SELECT decimal20_0In(floatVal) FROM srcTestTable WHERE float...
1825               ^
1826HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1827SELECT decimal20_0In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1828 decimal20_0in 
1829---------------
1830             1
1831(1 row)
1832
1833SELECT decimal20_0In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1834 decimal20_0in 
1835---------------
1836             1
1837(1 row)
1838
1839SELECT decimal20_0In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1840 decimal20_0in 
1841---------------
1842             1
1843(1 row)
1844
1845SELECT decimal20_0In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1846 decimal20_0in 
1847---------------
1848          1.00
1849(1 row)
1850
1851SELECT decimal20_0In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
1852   decimal20_0in   
1853-------------------
1854 1.000000000000000
1855(1 row)
1856
1857SELECT decimal20_0In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1858 decimal20_0in 
1859---------------
1860     1.0000000
1861(1 row)
1862
1863SELECT decimal20_0In(binaryVal) FROM srcTestTable LIMIT 1;
1864psql:implicitCasts.sql:482: ERROR:  function decimal20_0in(bytea) does not exist
1865LINE 1: SELECT decimal20_0In(binaryVal) FROM srcTestTable LIMIT 1;
1866               ^
1867HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1868SELECT decimal20_0In(booleanVal) FROM srcTestTable LIMIT 1;
1869psql:implicitCasts.sql:483: ERROR:  function decimal20_0in(boolean) does not exist
1870LINE 1: SELECT decimal20_0In(booleanVal) FROM srcTestTable LIMIT 1;
1871               ^
1872HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1873SELECT decimal20_0In(stringVal) FROM srcTestTable LIMIT 1;
1874psql:implicitCasts.sql:484: ERROR:  function decimal20_0in(text) does not exist
1875LINE 1: SELECT decimal20_0In(stringVal) FROM srcTestTable LIMIT 1;
1876               ^
1877HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1878SELECT decimal20_0In(dateVal) FROM srcTestTable LIMIT 1;
1879psql:implicitCasts.sql:485: ERROR:  function decimal20_0in(date) does not exist
1880LINE 1: SELECT decimal20_0In(dateVal) FROM srcTestTable LIMIT 1;
1881               ^
1882HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1883SELECT decimal20_0In(timestampVal) FROM srcTestTable LIMIT 1;
1884psql:implicitCasts.sql:486: ERROR:  function decimal20_0in(timestamp without time zone) does not exist
1885LINE 1: SELECT decimal20_0In(timestampVal) FROM srcTestTable LIMIT 1...
1886               ^
1887HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1888SELECT decimal20_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1889psql:implicitCasts.sql:487: ERROR:  function decimal20_0in(integer[]) does not exist
1890LINE 1: SELECT decimal20_0In(arrayIntVal) FROM srcTestTable LIMIT 1;
1891               ^
1892HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1893SELECT decimal20_0In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
1894psql:implicitCasts.sql:488: ERROR:  function decimal20_0in(double precision[]) does not exist
1895LINE 1: SELECT decimal20_0In(arrayDoubleVal) FROM srcTestTable LIMIT...
1896               ^
1897HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1898SELECT decimal20_0In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
1899psql:implicitCasts.sql:489: ERROR:  function decimal20_0in(structintdoublety) does not exist
1900LINE 1: SELECT decimal20_0In(structIntDoubleVal) FROM srcTestTable L...
1901               ^
1902HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1903SELECT decimal20_0In(structStringIntVal) FROM srcTestTable LIMIT 1;
1904psql:implicitCasts.sql:490: ERROR:  function decimal20_0in(structstringintty) does not exist
1905LINE 1: SELECT decimal20_0In(structStringIntVal) FROM srcTestTable L...
1906               ^
1907HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1908SELECT decimal20_0In(null);
1909 decimal20_0in 
1910---------------
1911          NULL
1912(1 row)
1913
1914-- from * to decimal(30, 15)
1915DROP FUNCTION IF EXISTS decimal30_15In;
1916DROP FUNCTION
1917CREATE FUNCTION decimal30_15In(decimal(30, 15)) RETURNS decimal(30, 15)
1918  AS 'select $1;'
1919  LANGUAGE SQL
1920  IMMUTABLE
1921  RETURNS NULL ON NULL INPUT;
1922CREATE FUNCTION
1923SELECT decimal30_15In(shortVal) FROM srcTestTable WHERE shortVal = 1;
1924 decimal30_15in 
1925----------------
1926              1
1927(1 row)
1928
1929SELECT decimal30_15In(intVal) FROM srcTestTable WHERE intVal = 1;
1930 decimal30_15in 
1931----------------
1932              1
1933(1 row)
1934
1935SELECT decimal30_15In(longVal) FROM srcTestTable WHERE longVal = 1;
1936 decimal30_15in 
1937----------------
1938              1
1939(1 row)
1940
1941SELECT decimal30_15In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
1942psql:implicitCasts.sql:504: ERROR:  function decimal30_15in(double precision) does not exist
1943LINE 1: SELECT decimal30_15In(doubleVal) FROM srcTestTable WHERE dou...
1944               ^
1945HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1946SELECT decimal30_15In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
1947psql:implicitCasts.sql:505: ERROR:  function decimal30_15in(real) does not exist
1948LINE 1: SELECT decimal30_15In(floatVal) FROM srcTestTable WHERE floa...
1949               ^
1950HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1951SELECT decimal30_15In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
1952 decimal30_15in 
1953----------------
1954              1
1955(1 row)
1956
1957SELECT decimal30_15In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
1958 decimal30_15in 
1959----------------
1960              1
1961(1 row)
1962
1963SELECT decimal30_15In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
1964 decimal30_15in 
1965----------------
1966              1
1967(1 row)
1968
1969SELECT decimal30_15In(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
1970 decimal30_15in 
1971----------------
1972           1.00
1973(1 row)
1974
1975SELECT decimal30_15In(decimal14_7Val) FROM srcTestTable WHERE decimal14_7Val = 1;
1976 decimal30_15in 
1977----------------
1978      1.0000000
1979(1 row)
1980
1981SELECT decimal30_15In(binaryVal) FROM srcTestTable LIMIT 1;
1982psql:implicitCasts.sql:511: ERROR:  function decimal30_15in(bytea) does not exist
1983LINE 1: SELECT decimal30_15In(binaryVal) FROM srcTestTable LIMIT 1;
1984               ^
1985HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1986SELECT decimal30_15In(booleanVal) FROM srcTestTable LIMIT 1;
1987psql:implicitCasts.sql:512: ERROR:  function decimal30_15in(boolean) does not exist
1988LINE 1: SELECT decimal30_15In(booleanVal) FROM srcTestTable LIMIT 1;
1989               ^
1990HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1991SELECT decimal30_15In(stringVal) FROM srcTestTable LIMIT 1;
1992psql:implicitCasts.sql:513: ERROR:  function decimal30_15in(text) does not exist
1993LINE 1: SELECT decimal30_15In(stringVal) FROM srcTestTable LIMIT 1;
1994               ^
1995HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
1996SELECT decimal30_15In(dateVal) FROM srcTestTable LIMIT 1;
1997psql:implicitCasts.sql:514: ERROR:  function decimal30_15in(date) does not exist
1998LINE 1: SELECT decimal30_15In(dateVal) FROM srcTestTable LIMIT 1;
1999               ^
2000HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2001SELECT decimal30_15In(timestampVal) FROM srcTestTable LIMIT 1;
2002psql:implicitCasts.sql:515: ERROR:  function decimal30_15in(timestamp without time zone) does not exist
2003LINE 1: SELECT decimal30_15In(timestampVal) FROM srcTestTable LIMIT ...
2004               ^
2005HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2006SELECT decimal30_15In(arrayIntVal) FROM srcTestTable LIMIT 1;
2007psql:implicitCasts.sql:516: ERROR:  function decimal30_15in(integer[]) does not exist
2008LINE 1: SELECT decimal30_15In(arrayIntVal) FROM srcTestTable LIMIT 1...
2009               ^
2010HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2011SELECT decimal30_15In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2012psql:implicitCasts.sql:517: ERROR:  function decimal30_15in(double precision[]) does not exist
2013LINE 1: SELECT decimal30_15In(arrayDoubleVal) FROM srcTestTable LIMI...
2014               ^
2015HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2016SELECT decimal30_15In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2017psql:implicitCasts.sql:518: ERROR:  function decimal30_15in(structintdoublety) does not exist
2018LINE 1: SELECT decimal30_15In(structIntDoubleVal) FROM srcTestTable ...
2019               ^
2020HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2021SELECT decimal30_15In(structStringIntVal) FROM srcTestTable LIMIT 1;
2022psql:implicitCasts.sql:519: ERROR:  function decimal30_15in(structstringintty) does not exist
2023LINE 1: SELECT decimal30_15In(structStringIntVal) FROM srcTestTable ...
2024               ^
2025HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2026SELECT decimal30_15In(null);
2027 decimal30_15in 
2028----------------
2029           NULL
2030(1 row)
2031
2032-- from * to decimal(14, 7)
2033DROP FUNCTION IF EXISTS decimal14_7In;
2034DROP FUNCTION
2035CREATE FUNCTION decimal14_7In(decimal(14, 7)) RETURNS decimal(14, 7)
2036  AS 'select $1;'
2037  LANGUAGE SQL
2038  IMMUTABLE
2039  RETURNS NULL ON NULL INPUT;
2040CREATE FUNCTION
2041SELECT decimal14_7In(shortVal) FROM srcTestTable WHERE shortVal = 1;
2042 decimal14_7in 
2043---------------
2044             1
2045(1 row)
2046
2047SELECT decimal14_7In(intVal) FROM srcTestTable WHERE intVal = 1;
2048 decimal14_7in 
2049---------------
2050             1
2051(1 row)
2052
2053SELECT decimal14_7In(longVal) FROM srcTestTable WHERE longVal = 1;
2054 decimal14_7in 
2055---------------
2056             1
2057(1 row)
2058
2059SELECT decimal14_7In(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2060psql:implicitCasts.sql:533: ERROR:  function decimal14_7in(double precision) does not exist
2061LINE 1: SELECT decimal14_7In(doubleVal) FROM srcTestTable WHERE doub...
2062               ^
2063HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2064SELECT decimal14_7In(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2065psql:implicitCasts.sql:534: ERROR:  function decimal14_7in(real) does not exist
2066LINE 1: SELECT decimal14_7In(floatVal) FROM srcTestTable WHERE float...
2067               ^
2068HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2069SELECT decimal14_7In(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2070 decimal14_7in 
2071---------------
2072             1
2073(1 row)
2074
2075SELECT decimal14_7In(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2076 decimal14_7in 
2077---------------
2078             1
2079(1 row)
2080
2081SELECT decimal14_7In(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2082 decimal14_7in 
2083---------------
2084             1
2085(1 row)
2086
2087SELECT decimal14_7In(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2088   decimal14_7in   
2089-------------------
2090 1.000000000000000
2091(1 row)
2092
2093SELECT decimal14_7In(decimal30_15Val::decimal(14, 7)) FROM srcTestTable WHERE decimal30_15Val = 1;
2094 decimal14_7in 
2095---------------
2096     1.0000000
2097(1 row)
2098
2099SELECT decimal14_7In(binaryVal) FROM srcTestTable LIMIT 1;
2100psql:implicitCasts.sql:540: ERROR:  function decimal14_7in(bytea) does not exist
2101LINE 1: SELECT decimal14_7In(binaryVal) FROM srcTestTable LIMIT 1;
2102               ^
2103HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2104SELECT decimal14_7In(booleanVal) FROM srcTestTable LIMIT 1;
2105psql:implicitCasts.sql:541: ERROR:  function decimal14_7in(boolean) does not exist
2106LINE 1: SELECT decimal14_7In(booleanVal) FROM srcTestTable LIMIT 1;
2107               ^
2108HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2109SELECT decimal14_7In(stringVal) FROM srcTestTable LIMIT 1;
2110psql:implicitCasts.sql:542: ERROR:  function decimal14_7in(text) does not exist
2111LINE 1: SELECT decimal14_7In(stringVal) FROM srcTestTable LIMIT 1;
2112               ^
2113HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2114SELECT decimal14_7In(dateVal) FROM srcTestTable LIMIT 1;
2115psql:implicitCasts.sql:543: ERROR:  function decimal14_7in(date) does not exist
2116LINE 1: SELECT decimal14_7In(dateVal) FROM srcTestTable LIMIT 1;
2117               ^
2118HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2119SELECT decimal14_7In(timestampVal) FROM srcTestTable LIMIT 1;
2120psql:implicitCasts.sql:544: ERROR:  function decimal14_7in(timestamp without time zone) does not exist
2121LINE 1: SELECT decimal14_7In(timestampVal) FROM srcTestTable LIMIT 1...
2122               ^
2123HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2124SELECT decimal14_7In(arrayIntVal) FROM srcTestTable LIMIT 1;
2125psql:implicitCasts.sql:545: ERROR:  function decimal14_7in(integer[]) does not exist
2126LINE 1: SELECT decimal14_7In(arrayIntVal) FROM srcTestTable LIMIT 1;
2127               ^
2128HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2129SELECT decimal14_7In(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2130psql:implicitCasts.sql:546: ERROR:  function decimal14_7in(double precision[]) does not exist
2131LINE 1: SELECT decimal14_7In(arrayDoubleVal) FROM srcTestTable LIMIT...
2132               ^
2133HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2134SELECT decimal14_7In(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2135psql:implicitCasts.sql:547: ERROR:  function decimal14_7in(structintdoublety) does not exist
2136LINE 1: SELECT decimal14_7In(structIntDoubleVal) FROM srcTestTable L...
2137               ^
2138HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2139SELECT decimal14_7In(structStringIntVal) FROM srcTestTable LIMIT 1;
2140psql:implicitCasts.sql:548: ERROR:  function decimal14_7in(structstringintty) does not exist
2141LINE 1: SELECT decimal14_7In(structStringIntVal) FROM srcTestTable L...
2142               ^
2143HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2144SELECT decimal14_7In(null);
2145 decimal14_7in 
2146---------------
2147          NULL
2148(1 row)
2149
2150-- from * to binary
2151DROP FUNCTION IF EXISTS binaryIn;
2152DROP FUNCTION
2153CREATE FUNCTION binaryIn(bytea) RETURNS bytea
2154  AS 'select $1;'
2155  LANGUAGE SQL
2156  IMMUTABLE
2157  RETURNS NULL ON NULL INPUT;
2158CREATE FUNCTION
2159SELECT binaryIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2160psql:implicitCasts.sql:559: ERROR:  function binaryin(smallint) does not exist
2161LINE 1: SELECT binaryIn(shortVal) FROM srcTestTable WHERE shortVal =...
2162               ^
2163HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2164SELECT binaryIn(intVal) FROM srcTestTable WHERE intVal = 1;
2165psql:implicitCasts.sql:560: ERROR:  function binaryin(integer) does not exist
2166LINE 1: SELECT binaryIn(intVal) FROM srcTestTable WHERE intVal = 1;
2167               ^
2168HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2169SELECT binaryIn(longVal) FROM srcTestTable WHERE longVal = 1;
2170psql:implicitCasts.sql:561: ERROR:  function binaryin(bigint) does not exist
2171LINE 1: SELECT binaryIn(longVal) FROM srcTestTable WHERE longVal = 1...
2172               ^
2173HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2174SELECT binaryIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2175psql:implicitCasts.sql:562: ERROR:  function binaryin(double precision) does not exist
2176LINE 1: SELECT binaryIn(doubleVal) FROM srcTestTable WHERE doubleVal...
2177               ^
2178HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2179SELECT binaryIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2180psql:implicitCasts.sql:563: ERROR:  function binaryin(real) does not exist
2181LINE 1: SELECT binaryIn(floatVal) FROM srcTestTable WHERE floatVal< ...
2182               ^
2183HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2184SELECT binaryIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2185psql:implicitCasts.sql:564: ERROR:  function binaryin(numeric) does not exist
2186LINE 1: SELECT binaryIn(decimal3_0Val) FROM srcTestTable WHERE decim...
2187               ^
2188HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2189SELECT binaryIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2190psql:implicitCasts.sql:565: ERROR:  function binaryin(numeric) does not exist
2191LINE 1: SELECT binaryIn(decimal5_0Val) FROM srcTestTable WHERE decim...
2192               ^
2193HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2194SELECT binaryIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2195psql:implicitCasts.sql:566: ERROR:  function binaryin(numeric) does not exist
2196LINE 1: SELECT binaryIn(decimal10_0Val) FROM srcTestTable WHERE deci...
2197               ^
2198HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2199SELECT binaryIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2200psql:implicitCasts.sql:567: ERROR:  function binaryin(numeric) does not exist
2201LINE 1: SELECT binaryIn(decimal10_2Val) FROM srcTestTable WHERE deci...
2202               ^
2203HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2204SELECT binaryIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2205psql:implicitCasts.sql:568: ERROR:  function binaryin(numeric) does not exist
2206LINE 1: SELECT binaryIn(decimal30_15Val) FROM srcTestTable WHERE dec...
2207               ^
2208HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2209SELECT binaryIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2210psql:implicitCasts.sql:569: ERROR:  column "decimal14_7in" does not exist
2211LINE 1: SELECT binaryIn(decimal14_7In) FROM srcTestTable WHERE decim...
2212                        ^
2213HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2214SELECT binaryIn(booleanVal) FROM srcTestTable LIMIT 1;
2215psql:implicitCasts.sql:570: ERROR:  function binaryin(boolean) does not exist
2216LINE 1: SELECT binaryIn(booleanVal) FROM srcTestTable LIMIT 1;
2217               ^
2218HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2219SELECT binaryIn(stringVal) FROM srcTestTable LIMIT 1;
2220psql:implicitCasts.sql:571: ERROR:  function binaryin(text) does not exist
2221LINE 1: SELECT binaryIn(stringVal) FROM srcTestTable LIMIT 1;
2222               ^
2223HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2224SELECT binaryIn(dateVal) FROM srcTestTable LIMIT 1;
2225psql:implicitCasts.sql:572: ERROR:  function binaryin(date) does not exist
2226LINE 1: SELECT binaryIn(dateVal) FROM srcTestTable LIMIT 1;
2227               ^
2228HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2229SELECT binaryIn(timestampVal) FROM srcTestTable LIMIT 1;
2230psql:implicitCasts.sql:573: ERROR:  function binaryin(timestamp without time zone) does not exist
2231LINE 1: SELECT binaryIn(timestampVal) FROM srcTestTable LIMIT 1;
2232               ^
2233HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2234SELECT binaryIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2235psql:implicitCasts.sql:574: ERROR:  function binaryin(integer[]) does not exist
2236LINE 1: SELECT binaryIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2237               ^
2238HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2239SELECT binaryIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2240psql:implicitCasts.sql:575: ERROR:  function binaryin(double precision[]) does not exist
2241LINE 1: SELECT binaryIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2242               ^
2243HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2244SELECT binaryIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2245psql:implicitCasts.sql:576: ERROR:  function binaryin(structintdoublety) does not exist
2246LINE 1: SELECT binaryIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
2247               ^
2248HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2249SELECT binaryIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2250psql:implicitCasts.sql:577: ERROR:  function binaryin(structstringintty) does not exist
2251LINE 1: SELECT binaryIn(structStringIntVal) FROM srcTestTable LIMIT ...
2252               ^
2253HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2254SELECT binaryIn(null);
2255 binaryin 
2256----------
2257 NULL
2258(1 row)
2259
2260-- from * to boolean
2261DROP FUNCTION IF EXISTS booleanIn;
2262DROP FUNCTION
2263CREATE FUNCTION booleanIn(boolean) RETURNS boolean
2264  AS 'select $1;'
2265  LANGUAGE SQL
2266  IMMUTABLE
2267  RETURNS NULL ON NULL INPUT;
2268CREATE FUNCTION
2269SELECT booleanIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2270psql:implicitCasts.sql:588: ERROR:  function booleanin(smallint) does not exist
2271LINE 1: SELECT booleanIn(shortVal) FROM srcTestTable WHERE shortVal ...
2272               ^
2273HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2274SELECT booleanIn(intVal) FROM srcTestTable WHERE intVal = 1;
2275psql:implicitCasts.sql:589: ERROR:  function booleanin(integer) does not exist
2276LINE 1: SELECT booleanIn(intVal) FROM srcTestTable WHERE intVal = 1;
2277               ^
2278HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2279SELECT booleanIn(longVal) FROM srcTestTable WHERE longVal = 1;
2280psql:implicitCasts.sql:590: ERROR:  function booleanin(bigint) does not exist
2281LINE 1: SELECT booleanIn(longVal) FROM srcTestTable WHERE longVal = ...
2282               ^
2283HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2284SELECT booleanIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2285psql:implicitCasts.sql:591: ERROR:  function booleanin(double precision) does not exist
2286LINE 1: SELECT booleanIn(doubleVal) FROM srcTestTable WHERE doubleVa...
2287               ^
2288HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2289SELECT booleanIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2290psql:implicitCasts.sql:592: ERROR:  function booleanin(real) does not exist
2291LINE 1: SELECT booleanIn(floatVal) FROM srcTestTable WHERE floatVal<...
2292               ^
2293HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2294SELECT booleanIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2295psql:implicitCasts.sql:593: ERROR:  function booleanin(numeric) does not exist
2296LINE 1: SELECT booleanIn(decimal3_0Val) FROM srcTestTable WHERE deci...
2297               ^
2298HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2299SELECT booleanIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2300psql:implicitCasts.sql:594: ERROR:  function booleanin(numeric) does not exist
2301LINE 1: SELECT booleanIn(decimal5_0Val) FROM srcTestTable WHERE deci...
2302               ^
2303HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2304SELECT booleanIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2305psql:implicitCasts.sql:595: ERROR:  function booleanin(numeric) does not exist
2306LINE 1: SELECT booleanIn(decimal10_0Val) FROM srcTestTable WHERE dec...
2307               ^
2308HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2309SELECT booleanIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2310psql:implicitCasts.sql:596: ERROR:  function booleanin(numeric) does not exist
2311LINE 1: SELECT booleanIn(decimal10_2Val) FROM srcTestTable WHERE dec...
2312               ^
2313HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2314SELECT booleanIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2315psql:implicitCasts.sql:597: ERROR:  function booleanin(numeric) does not exist
2316LINE 1: SELECT booleanIn(decimal30_15Val) FROM srcTestTable WHERE de...
2317               ^
2318HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2319SELECT booleanIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2320psql:implicitCasts.sql:598: ERROR:  column "decimal14_7in" does not exist
2321LINE 1: SELECT booleanIn(decimal14_7In) FROM srcTestTable WHERE deci...
2322                         ^
2323HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2324SELECT booleanIn(binaryVal) FROM srcTestTable LIMIT 1;
2325psql:implicitCasts.sql:599: ERROR:  function booleanin(bytea) does not exist
2326LINE 1: SELECT booleanIn(binaryVal) FROM srcTestTable LIMIT 1;
2327               ^
2328HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2329SELECT booleanIn(stringVal) FROM srcTestTable LIMIT 1;
2330psql:implicitCasts.sql:600: ERROR:  function booleanin(text) does not exist
2331LINE 1: SELECT booleanIn(stringVal) FROM srcTestTable LIMIT 1;
2332               ^
2333HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2334SELECT booleanIn(dateVal) FROM srcTestTable LIMIT 1;
2335psql:implicitCasts.sql:601: ERROR:  function booleanin(date) does not exist
2336LINE 1: SELECT booleanIn(dateVal) FROM srcTestTable LIMIT 1;
2337               ^
2338HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2339SELECT booleanIn(timestampVal) FROM srcTestTable LIMIT 1;
2340psql:implicitCasts.sql:602: ERROR:  function booleanin(timestamp without time zone) does not exist
2341LINE 1: SELECT booleanIn(timestampVal) FROM srcTestTable LIMIT 1;
2342               ^
2343HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2344SELECT booleanIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2345psql:implicitCasts.sql:603: ERROR:  function booleanin(integer[]) does not exist
2346LINE 1: SELECT booleanIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2347               ^
2348HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2349SELECT booleanIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2350psql:implicitCasts.sql:604: ERROR:  function booleanin(double precision[]) does not exist
2351LINE 1: SELECT booleanIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2352               ^
2353HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2354SELECT booleanIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2355psql:implicitCasts.sql:605: ERROR:  function booleanin(structintdoublety) does not exist
2356LINE 1: SELECT booleanIn(structIntDoubleVal) FROM srcTestTable LIMIT...
2357               ^
2358HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2359SELECT booleanIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2360psql:implicitCasts.sql:606: ERROR:  function booleanin(structstringintty) does not exist
2361LINE 1: SELECT booleanIn(structStringIntVal) FROM srcTestTable LIMIT...
2362               ^
2363HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2364SELECT booleanIn(null);
2365 booleanin 
2366-----------
2367 NULL
2368(1 row)
2369
2370-- from * to string
2371DROP FUNCTION IF EXISTS stringIn;
2372DROP FUNCTION
2373CREATE FUNCTION stringIn(text) RETURNS text
2374  AS 'select $1;'
2375  LANGUAGE SQL
2376  IMMUTABLE
2377  RETURNS NULL ON NULL INPUT;
2378CREATE FUNCTION
2379SELECT stringIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2380psql:implicitCasts.sql:617: ERROR:  function stringin(smallint) does not exist
2381LINE 1: SELECT stringIn(shortVal) FROM srcTestTable WHERE shortVal =...
2382               ^
2383HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2384SELECT stringIn(intVal) FROM srcTestTable WHERE intVal = 1;
2385psql:implicitCasts.sql:618: ERROR:  function stringin(integer) does not exist
2386LINE 1: SELECT stringIn(intVal) FROM srcTestTable WHERE intVal = 1;
2387               ^
2388HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2389SELECT stringIn(longVal) FROM srcTestTable WHERE longVal = 1;
2390psql:implicitCasts.sql:619: ERROR:  function stringin(bigint) does not exist
2391LINE 1: SELECT stringIn(longVal) FROM srcTestTable WHERE longVal = 1...
2392               ^
2393HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2394SELECT stringIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2395psql:implicitCasts.sql:620: ERROR:  function stringin(double precision) does not exist
2396LINE 1: SELECT stringIn(doubleVal) FROM srcTestTable WHERE doubleVal...
2397               ^
2398HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2399SELECT stringIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2400psql:implicitCasts.sql:621: ERROR:  function stringin(real) does not exist
2401LINE 1: SELECT stringIn(floatVal) FROM srcTestTable WHERE floatVal< ...
2402               ^
2403HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2404SELECT stringIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2405psql:implicitCasts.sql:622: ERROR:  function stringin(numeric) does not exist
2406LINE 1: SELECT stringIn(decimal3_0Val) FROM srcTestTable WHERE decim...
2407               ^
2408HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2409SELECT stringIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2410psql:implicitCasts.sql:623: ERROR:  function stringin(numeric) does not exist
2411LINE 1: SELECT stringIn(decimal5_0Val) FROM srcTestTable WHERE decim...
2412               ^
2413HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2414SELECT stringIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2415psql:implicitCasts.sql:624: ERROR:  function stringin(numeric) does not exist
2416LINE 1: SELECT stringIn(decimal10_0Val) FROM srcTestTable WHERE deci...
2417               ^
2418HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2419SELECT stringIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2420psql:implicitCasts.sql:625: ERROR:  function stringin(numeric) does not exist
2421LINE 1: SELECT stringIn(decimal10_2Val) FROM srcTestTable WHERE deci...
2422               ^
2423HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2424SELECT stringIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2425psql:implicitCasts.sql:626: ERROR:  function stringin(numeric) does not exist
2426LINE 1: SELECT stringIn(decimal30_15Val) FROM srcTestTable WHERE dec...
2427               ^
2428HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2429SELECT stringIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2430psql:implicitCasts.sql:627: ERROR:  column "decimal14_7in" does not exist
2431LINE 1: SELECT stringIn(decimal14_7In) FROM srcTestTable WHERE decim...
2432                        ^
2433HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2434SELECT stringIn(binaryVal) FROM srcTestTable LIMIT 1;
2435psql:implicitCasts.sql:628: ERROR:  function stringin(bytea) does not exist
2436LINE 1: SELECT stringIn(binaryVal) FROM srcTestTable LIMIT 1;
2437               ^
2438HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2439SELECT stringIn(booleanVal) FROM srcTestTable LIMIT 1;
2440psql:implicitCasts.sql:629: ERROR:  function stringin(boolean) does not exist
2441LINE 1: SELECT stringIn(booleanVal) FROM srcTestTable LIMIT 1;
2442               ^
2443HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2444SELECT stringIn(dateVal) FROM srcTestTable LIMIT 1;
2445psql:implicitCasts.sql:630: ERROR:  function stringin(date) does not exist
2446LINE 1: SELECT stringIn(dateVal) FROM srcTestTable LIMIT 1;
2447               ^
2448HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2449SELECT stringIn(timestampVal) FROM srcTestTable LIMIT 1;
2450psql:implicitCasts.sql:631: ERROR:  function stringin(timestamp without time zone) does not exist
2451LINE 1: SELECT stringIn(timestampVal) FROM srcTestTable LIMIT 1;
2452               ^
2453HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2454SELECT stringIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2455psql:implicitCasts.sql:632: ERROR:  function stringin(integer[]) does not exist
2456LINE 1: SELECT stringIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2457               ^
2458HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2459SELECT stringIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2460psql:implicitCasts.sql:633: ERROR:  function stringin(double precision[]) does not exist
2461LINE 1: SELECT stringIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2462               ^
2463HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2464SELECT stringIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2465psql:implicitCasts.sql:634: ERROR:  function stringin(structintdoublety) does not exist
2466LINE 1: SELECT stringIn(structIntDoubleVal) FROM srcTestTable LIMIT ...
2467               ^
2468HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2469SELECT stringIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2470psql:implicitCasts.sql:635: ERROR:  function stringin(structstringintty) does not exist
2471LINE 1: SELECT stringIn(structStringIntVal) FROM srcTestTable LIMIT ...
2472               ^
2473HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2474SELECT stringIn(null);
2475 stringin 
2476----------
2477 NULL
2478(1 row)
2479
2480-- from * to date
2481DROP FUNCTION IF EXISTS dateIn;
2482DROP FUNCTION
2483CREATE FUNCTION dateIn(date) RETURNS date
2484  AS 'select $1;'
2485  LANGUAGE SQL
2486  IMMUTABLE
2487  RETURNS NULL ON NULL INPUT;
2488CREATE FUNCTION
2489SELECT dateIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2490psql:implicitCasts.sql:646: ERROR:  function datein(smallint) does not exist
2491LINE 1: SELECT dateIn(shortVal) FROM srcTestTable WHERE shortVal = 1...
2492               ^
2493HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2494SELECT dateIn(intVal) FROM srcTestTable WHERE intVal = 1;
2495psql:implicitCasts.sql:647: ERROR:  function datein(integer) does not exist
2496LINE 1: SELECT dateIn(intVal) FROM srcTestTable WHERE intVal = 1;
2497               ^
2498HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2499SELECT dateIn(longVal) FROM srcTestTable WHERE longVal = 1;
2500psql:implicitCasts.sql:648: ERROR:  function datein(bigint) does not exist
2501LINE 1: SELECT dateIn(longVal) FROM srcTestTable WHERE longVal = 1;
2502               ^
2503HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2504SELECT dateIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2505psql:implicitCasts.sql:649: ERROR:  function datein(double precision) does not exist
2506LINE 1: SELECT dateIn(doubleVal) FROM srcTestTable WHERE doubleVal <...
2507               ^
2508HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2509SELECT dateIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2510psql:implicitCasts.sql:650: ERROR:  function datein(real) does not exist
2511LINE 1: SELECT dateIn(floatVal) FROM srcTestTable WHERE floatVal< 1....
2512               ^
2513HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2514SELECT dateIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2515psql:implicitCasts.sql:651: ERROR:  function datein(numeric) does not exist
2516LINE 1: SELECT dateIn(decimal3_0Val) FROM srcTestTable WHERE decimal...
2517               ^
2518HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2519SELECT dateIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2520psql:implicitCasts.sql:652: ERROR:  function datein(numeric) does not exist
2521LINE 1: SELECT dateIn(decimal5_0Val) FROM srcTestTable WHERE decimal...
2522               ^
2523HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2524SELECT dateIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2525psql:implicitCasts.sql:653: ERROR:  function datein(numeric) does not exist
2526LINE 1: SELECT dateIn(decimal10_0Val) FROM srcTestTable WHERE decima...
2527               ^
2528HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2529SELECT dateIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2530psql:implicitCasts.sql:654: ERROR:  function datein(numeric) does not exist
2531LINE 1: SELECT dateIn(decimal10_2Val) FROM srcTestTable WHERE decima...
2532               ^
2533HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2534SELECT dateIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2535psql:implicitCasts.sql:655: ERROR:  function datein(numeric) does not exist
2536LINE 1: SELECT dateIn(decimal30_15Val) FROM srcTestTable WHERE decim...
2537               ^
2538HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2539SELECT dateIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2540psql:implicitCasts.sql:656: ERROR:  column "decimal14_7in" does not exist
2541LINE 1: SELECT dateIn(decimal14_7In) FROM srcTestTable WHERE decimal...
2542                      ^
2543HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2544SELECT dateIn(binaryVal) FROM srcTestTable LIMIT 1;
2545psql:implicitCasts.sql:657: ERROR:  function datein(bytea) does not exist
2546LINE 1: SELECT dateIn(binaryVal) FROM srcTestTable LIMIT 1;
2547               ^
2548HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2549SELECT dateIn(booleanVal) FROM srcTestTable LIMIT 1;
2550psql:implicitCasts.sql:658: ERROR:  function datein(boolean) does not exist
2551LINE 1: SELECT dateIn(booleanVal) FROM srcTestTable LIMIT 1;
2552               ^
2553HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2554SELECT dateIn(stringVal) FROM srcTestTable LIMIT 1;
2555psql:implicitCasts.sql:659: ERROR:  function datein(text) does not exist
2556LINE 1: SELECT dateIn(stringVal) FROM srcTestTable LIMIT 1;
2557               ^
2558HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2559SELECT dateIn(timestampVal) FROM srcTestTable LIMIT 1;
2560psql:implicitCasts.sql:660: ERROR:  function datein(timestamp without time zone) does not exist
2561LINE 1: SELECT dateIn(timestampVal) FROM srcTestTable LIMIT 1;
2562               ^
2563HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2564SELECT dateIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2565psql:implicitCasts.sql:661: ERROR:  function datein(integer[]) does not exist
2566LINE 1: SELECT dateIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2567               ^
2568HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2569SELECT dateIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2570psql:implicitCasts.sql:662: ERROR:  function datein(double precision[]) does not exist
2571LINE 1: SELECT dateIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2572               ^
2573HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2574SELECT dateIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2575psql:implicitCasts.sql:663: ERROR:  function datein(structintdoublety) does not exist
2576LINE 1: SELECT dateIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2577               ^
2578HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2579SELECT dateIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2580psql:implicitCasts.sql:664: ERROR:  function datein(structstringintty) does not exist
2581LINE 1: SELECT dateIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2582               ^
2583HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2584SELECT dateIn(null);
2585 datein 
2586--------
2587 NULL
2588(1 row)
2589
2590-- from * to timestamp
2591DROP FUNCTION IF EXISTS timestampIn;
2592DROP FUNCTION
2593CREATE FUNCTION timestampIn(timestamp) RETURNS timestamp
2594  AS 'select $1;'
2595  LANGUAGE SQL
2596  IMMUTABLE
2597  RETURNS NULL ON NULL INPUT;
2598CREATE FUNCTION
2599SELECT timestampIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2600psql:implicitCasts.sql:675: ERROR:  function timestampin(smallint) does not exist
2601LINE 1: SELECT timestampIn(shortVal) FROM srcTestTable WHERE shortVa...
2602               ^
2603HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2604SELECT timestampIn(intVal) FROM srcTestTable WHERE intVal = 1;
2605psql:implicitCasts.sql:676: ERROR:  function timestampin(integer) does not exist
2606LINE 1: SELECT timestampIn(intVal) FROM srcTestTable WHERE intVal = ...
2607               ^
2608HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2609SELECT timestampIn(longVal) FROM srcTestTable WHERE longVal = 1;
2610psql:implicitCasts.sql:677: ERROR:  function timestampin(bigint) does not exist
2611LINE 1: SELECT timestampIn(longVal) FROM srcTestTable WHERE longVal ...
2612               ^
2613HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2614SELECT timestampIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2615psql:implicitCasts.sql:678: ERROR:  function timestampin(double precision) does not exist
2616LINE 1: SELECT timestampIn(doubleVal) FROM srcTestTable WHERE double...
2617               ^
2618HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2619SELECT timestampIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2620psql:implicitCasts.sql:679: ERROR:  function timestampin(real) does not exist
2621LINE 1: SELECT timestampIn(floatVal) FROM srcTestTable WHERE floatVa...
2622               ^
2623HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2624SELECT timestampIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2625psql:implicitCasts.sql:680: ERROR:  function timestampin(numeric) does not exist
2626LINE 1: SELECT timestampIn(decimal3_0Val) FROM srcTestTable WHERE de...
2627               ^
2628HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2629SELECT timestampIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2630psql:implicitCasts.sql:681: ERROR:  function timestampin(numeric) does not exist
2631LINE 1: SELECT timestampIn(decimal5_0Val) FROM srcTestTable WHERE de...
2632               ^
2633HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2634SELECT timestampIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2635psql:implicitCasts.sql:682: ERROR:  function timestampin(numeric) does not exist
2636LINE 1: SELECT timestampIn(decimal10_0Val) FROM srcTestTable WHERE d...
2637               ^
2638HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2639SELECT timestampIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2640psql:implicitCasts.sql:683: ERROR:  function timestampin(numeric) does not exist
2641LINE 1: SELECT timestampIn(decimal10_2Val) FROM srcTestTable WHERE d...
2642               ^
2643HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2644SELECT timestampIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2645psql:implicitCasts.sql:684: ERROR:  function timestampin(numeric) does not exist
2646LINE 1: SELECT timestampIn(decimal30_15Val) FROM srcTestTable WHERE ...
2647               ^
2648HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2649SELECT timestampIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2650psql:implicitCasts.sql:685: ERROR:  column "decimal14_7in" does not exist
2651LINE 1: SELECT timestampIn(decimal14_7In) FROM srcTestTable WHERE de...
2652                           ^
2653HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2654SELECT timestampIn(binaryVal) FROM srcTestTable LIMIT 1;
2655psql:implicitCasts.sql:686: ERROR:  function timestampin(bytea) does not exist
2656LINE 1: SELECT timestampIn(binaryVal) FROM srcTestTable LIMIT 1;
2657               ^
2658HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2659SELECT timestampIn(booleanVal) FROM srcTestTable LIMIT 1;
2660psql:implicitCasts.sql:687: ERROR:  function timestampin(boolean) does not exist
2661LINE 1: SELECT timestampIn(booleanVal) FROM srcTestTable LIMIT 1;
2662               ^
2663HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2664SELECT timestampIn(stringVal) FROM srcTestTable LIMIT 1;
2665psql:implicitCasts.sql:688: ERROR:  function timestampin(text) does not exist
2666LINE 1: SELECT timestampIn(stringVal) FROM srcTestTable LIMIT 1;
2667               ^
2668HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2669SELECT timestampIn(dateVal) FROM srcTestTable LIMIT 1;
2670     timestampin     
2671---------------------
2672 1970-01-01 00:00:00
2673(1 row)
2674
2675SELECT timestampIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2676psql:implicitCasts.sql:690: ERROR:  function timestampin(integer[]) does not exist
2677LINE 1: SELECT timestampIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2678               ^
2679HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2680SELECT timestampIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2681psql:implicitCasts.sql:691: ERROR:  function timestampin(double precision[]) does not exist
2682LINE 1: SELECT timestampIn(arrayDoubleVal) FROM srcTestTable LIMIT 1...
2683               ^
2684HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2685SELECT timestampIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2686psql:implicitCasts.sql:692: ERROR:  function timestampin(structintdoublety) does not exist
2687LINE 1: SELECT timestampIn(structIntDoubleVal) FROM srcTestTable LIM...
2688               ^
2689HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2690SELECT timestampIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2691psql:implicitCasts.sql:693: ERROR:  function timestampin(structstringintty) does not exist
2692LINE 1: SELECT timestampIn(structStringIntVal) FROM srcTestTable LIM...
2693               ^
2694HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2695SELECT timestampIn(null);
2696 timestampin 
2697-------------
2698 NULL
2699(1 row)
2700
2701-- from * to int[]
2702DROP FUNCTION IF EXISTS arrayIntIn;
2703DROP FUNCTION
2704CREATE FUNCTION arrayIntIn(int[]) RETURNS int[]
2705  AS 'select $1;'
2706  LANGUAGE SQL
2707  IMMUTABLE
2708  RETURNS NULL ON NULL INPUT;
2709CREATE FUNCTION
2710SELECT arrayIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2711psql:implicitCasts.sql:704: ERROR:  function arrayintin(smallint) does not exist
2712LINE 1: SELECT arrayIntIn(shortVal) FROM srcTestTable WHERE shortVal...
2713               ^
2714HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2715SELECT arrayIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
2716psql:implicitCasts.sql:705: ERROR:  function arrayintin(integer) does not exist
2717LINE 1: SELECT arrayIntIn(intVal) FROM srcTestTable WHERE intVal = 1...
2718               ^
2719HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2720SELECT arrayIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
2721psql:implicitCasts.sql:706: ERROR:  function arrayintin(bigint) does not exist
2722LINE 1: SELECT arrayIntIn(longVal) FROM srcTestTable WHERE longVal =...
2723               ^
2724HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2725SELECT arrayIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2726psql:implicitCasts.sql:707: ERROR:  function arrayintin(double precision) does not exist
2727LINE 1: SELECT arrayIntIn(doubleVal) FROM srcTestTable WHERE doubleV...
2728               ^
2729HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2730SELECT arrayIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2731psql:implicitCasts.sql:708: ERROR:  function arrayintin(real) does not exist
2732LINE 1: SELECT arrayIntIn(floatVal) FROM srcTestTable WHERE floatVal...
2733               ^
2734HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2735SELECT arrayIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2736psql:implicitCasts.sql:709: ERROR:  function arrayintin(numeric) does not exist
2737LINE 1: SELECT arrayIntIn(decimal3_0Val) FROM srcTestTable WHERE dec...
2738               ^
2739HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2740SELECT arrayIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2741psql:implicitCasts.sql:710: ERROR:  function arrayintin(numeric) does not exist
2742LINE 1: SELECT arrayIntIn(decimal5_0Val) FROM srcTestTable WHERE dec...
2743               ^
2744HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2745SELECT arrayIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2746psql:implicitCasts.sql:711: ERROR:  function arrayintin(numeric) does not exist
2747LINE 1: SELECT arrayIntIn(decimal10_0Val) FROM srcTestTable WHERE de...
2748               ^
2749HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2750SELECT arrayIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2751psql:implicitCasts.sql:712: ERROR:  function arrayintin(numeric) does not exist
2752LINE 1: SELECT arrayIntIn(decimal10_2Val) FROM srcTestTable WHERE de...
2753               ^
2754HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2755SELECT arrayIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2756psql:implicitCasts.sql:713: ERROR:  function arrayintin(numeric) does not exist
2757LINE 1: SELECT arrayIntIn(decimal30_15Val) FROM srcTestTable WHERE d...
2758               ^
2759HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2760SELECT arrayIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2761psql:implicitCasts.sql:714: ERROR:  column "decimal14_7in" does not exist
2762LINE 1: SELECT arrayIntIn(decimal14_7In) FROM srcTestTable WHERE dec...
2763                          ^
2764HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2765SELECT arrayIntIn(binaryVal) FROM srcTestTable LIMIT 1;
2766psql:implicitCasts.sql:715: ERROR:  function arrayintin(bytea) does not exist
2767LINE 1: SELECT arrayIntIn(binaryVal) FROM srcTestTable LIMIT 1;
2768               ^
2769HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2770SELECT arrayIntIn(booleanVal) FROM srcTestTable LIMIT 1;
2771psql:implicitCasts.sql:716: ERROR:  function arrayintin(boolean) does not exist
2772LINE 1: SELECT arrayIntIn(booleanVal) FROM srcTestTable LIMIT 1;
2773               ^
2774HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2775SELECT arrayIntIn(stringVal) FROM srcTestTable LIMIT 1;
2776psql:implicitCasts.sql:717: ERROR:  function arrayintin(text) does not exist
2777LINE 1: SELECT arrayIntIn(stringVal) FROM srcTestTable LIMIT 1;
2778               ^
2779HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2780SELECT arrayIntIn(dateVal) FROM srcTestTable LIMIT 1;
2781psql:implicitCasts.sql:718: ERROR:  function arrayintin(date) does not exist
2782LINE 1: SELECT arrayIntIn(dateVal) FROM srcTestTable LIMIT 1;
2783               ^
2784HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2785SELECT arrayIntIn(timestampVal) FROM srcTestTable LIMIT 1;
2786psql:implicitCasts.sql:719: ERROR:  function arrayintin(timestamp without time zone) does not exist
2787LINE 1: SELECT arrayIntIn(timestampVal) FROM srcTestTable LIMIT 1;
2788               ^
2789HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2790SELECT arrayIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2791psql:implicitCasts.sql:720: ERROR:  function arrayintin(double precision[]) does not exist
2792LINE 1: SELECT arrayIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
2793               ^
2794HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2795SELECT arrayIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2796psql:implicitCasts.sql:721: ERROR:  function arrayintin(structintdoublety) does not exist
2797LINE 1: SELECT arrayIntIn(structIntDoubleVal) FROM srcTestTable LIMI...
2798               ^
2799HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2800SELECT arrayIntIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2801psql:implicitCasts.sql:722: ERROR:  function arrayintin(structstringintty) does not exist
2802LINE 1: SELECT arrayIntIn(structStringIntVal) FROM srcTestTable LIMI...
2803               ^
2804HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2805SELECT arrayIntIn(null);
2806 arrayintin 
2807------------
2808 NULL
2809(1 row)
2810
2811-- from * to float8[]
2812DROP FUNCTION IF EXISTS arrayDoubleIn;
2813DROP FUNCTION
2814CREATE FUNCTION arrayDoubleIn(float8[]) RETURNS float8[]
2815  AS 'select $1;'
2816  LANGUAGE SQL
2817  IMMUTABLE
2818  RETURNS NULL ON NULL INPUT;
2819CREATE FUNCTION
2820SELECT arrayDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2821psql:implicitCasts.sql:733: ERROR:  function arraydoublein(smallint) does not exist
2822LINE 1: SELECT arrayDoubleIn(shortVal) FROM srcTestTable WHERE short...
2823               ^
2824HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2825SELECT arrayDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
2826psql:implicitCasts.sql:734: ERROR:  function arraydoublein(integer) does not exist
2827LINE 1: SELECT arrayDoubleIn(intVal) FROM srcTestTable WHERE intVal ...
2828               ^
2829HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2830SELECT arrayDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
2831psql:implicitCasts.sql:735: ERROR:  function arraydoublein(bigint) does not exist
2832LINE 1: SELECT arrayDoubleIn(longVal) FROM srcTestTable WHERE longVa...
2833               ^
2834HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2835SELECT arrayDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2836psql:implicitCasts.sql:736: ERROR:  function arraydoublein(double precision) does not exist
2837LINE 1: SELECT arrayDoubleIn(doubleVal) FROM srcTestTable WHERE doub...
2838               ^
2839HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2840SELECT arrayDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2841psql:implicitCasts.sql:737: ERROR:  function arraydoublein(real) does not exist
2842LINE 1: SELECT arrayDoubleIn(floatVal) FROM srcTestTable WHERE float...
2843               ^
2844HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2845SELECT arrayDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2846psql:implicitCasts.sql:738: ERROR:  function arraydoublein(numeric) does not exist
2847LINE 1: SELECT arrayDoubleIn(decimal3_0Val) FROM srcTestTable WHERE ...
2848               ^
2849HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2850SELECT arrayDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2851psql:implicitCasts.sql:739: ERROR:  function arraydoublein(numeric) does not exist
2852LINE 1: SELECT arrayDoubleIn(decimal5_0Val) FROM srcTestTable WHERE ...
2853               ^
2854HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2855SELECT arrayDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2856psql:implicitCasts.sql:740: ERROR:  function arraydoublein(numeric) does not exist
2857LINE 1: SELECT arrayDoubleIn(decimal10_0Val) FROM srcTestTable WHERE...
2858               ^
2859HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2860SELECT arrayDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2861psql:implicitCasts.sql:741: ERROR:  function arraydoublein(numeric) does not exist
2862LINE 1: SELECT arrayDoubleIn(decimal10_2Val) FROM srcTestTable WHERE...
2863               ^
2864HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2865SELECT arrayDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2866psql:implicitCasts.sql:742: ERROR:  function arraydoublein(numeric) does not exist
2867LINE 1: SELECT arrayDoubleIn(decimal30_15Val) FROM srcTestTable WHER...
2868               ^
2869HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2870SELECT arrayDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2871psql:implicitCasts.sql:743: ERROR:  column "decimal14_7in" does not exist
2872LINE 1: SELECT arrayDoubleIn(decimal14_7In) FROM srcTestTable WHERE ...
2873                             ^
2874HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2875SELECT arrayDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
2876psql:implicitCasts.sql:744: ERROR:  function arraydoublein(bytea) does not exist
2877LINE 1: SELECT arrayDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
2878               ^
2879HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2880SELECT arrayDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
2881psql:implicitCasts.sql:745: ERROR:  function arraydoublein(boolean) does not exist
2882LINE 1: SELECT arrayDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
2883               ^
2884HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2885SELECT arrayDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
2886psql:implicitCasts.sql:746: ERROR:  function arraydoublein(text) does not exist
2887LINE 1: SELECT arrayDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
2888               ^
2889HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2890SELECT arrayDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
2891psql:implicitCasts.sql:747: ERROR:  function arraydoublein(date) does not exist
2892LINE 1: SELECT arrayDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
2893               ^
2894HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2895SELECT arrayDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
2896psql:implicitCasts.sql:748: ERROR:  function arraydoublein(timestamp without time zone) does not exist
2897LINE 1: SELECT arrayDoubleIn(timestampVal) FROM srcTestTable LIMIT 1...
2898               ^
2899HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2900SELECT arrayDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
2901 arraydoublein 
2902---------------
2903 {1,2,3}
2904(1 row)
2905
2906SELECT arrayDoubleIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
2907psql:implicitCasts.sql:750: ERROR:  function arraydoublein(structintdoublety) does not exist
2908LINE 1: SELECT arrayDoubleIn(structIntDoubleVal) FROM srcTestTable L...
2909               ^
2910HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2911SELECT arrayDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
2912psql:implicitCasts.sql:751: ERROR:  function arraydoublein(structstringintty) does not exist
2913LINE 1: SELECT arrayDoubleIn(structStringIntVal) FROM srcTestTable L...
2914               ^
2915HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2916SELECT arrayDoubleIn(null);
2917 arraydoublein 
2918---------------
2919 NULL
2920(1 row)
2921
2922-- from * to structIntDoubleTy
2923DROP FUNCTION IF EXISTS structIntDoubleIn;
2924DROP FUNCTION
2925CREATE FUNCTION structIntDoubleIn(structIntDoubleTy) RETURNS structIntDoubleTy
2926  AS 'select $1;'
2927  LANGUAGE SQL
2928  IMMUTABLE
2929  RETURNS NULL ON NULL INPUT;
2930CREATE FUNCTION
2931SELECT structIntDoubleIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
2932psql:implicitCasts.sql:762: ERROR:  function structintdoublein(smallint) does not exist
2933LINE 1: SELECT structIntDoubleIn(shortVal) FROM srcTestTable WHERE s...
2934               ^
2935HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2936SELECT structIntDoubleIn(intVal) FROM srcTestTable WHERE intVal = 1;
2937psql:implicitCasts.sql:763: ERROR:  function structintdoublein(integer) does not exist
2938LINE 1: SELECT structIntDoubleIn(intVal) FROM srcTestTable WHERE int...
2939               ^
2940HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2941SELECT structIntDoubleIn(longVal) FROM srcTestTable WHERE longVal = 1;
2942psql:implicitCasts.sql:764: ERROR:  function structintdoublein(bigint) does not exist
2943LINE 1: SELECT structIntDoubleIn(longVal) FROM srcTestTable WHERE lo...
2944               ^
2945HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2946SELECT structIntDoubleIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
2947psql:implicitCasts.sql:765: ERROR:  function structintdoublein(double precision) does not exist
2948LINE 1: SELECT structIntDoubleIn(doubleVal) FROM srcTestTable WHERE ...
2949               ^
2950HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2951SELECT structIntDoubleIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
2952psql:implicitCasts.sql:766: ERROR:  function structintdoublein(real) does not exist
2953LINE 1: SELECT structIntDoubleIn(floatVal) FROM srcTestTable WHERE f...
2954               ^
2955HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2956SELECT structIntDoubleIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
2957psql:implicitCasts.sql:767: ERROR:  function structintdoublein(numeric) does not exist
2958LINE 1: SELECT structIntDoubleIn(decimal3_0Val) FROM srcTestTable WH...
2959               ^
2960HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2961SELECT structIntDoubleIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
2962psql:implicitCasts.sql:768: ERROR:  function structintdoublein(numeric) does not exist
2963LINE 1: SELECT structIntDoubleIn(decimal5_0Val) FROM srcTestTable WH...
2964               ^
2965HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2966SELECT structIntDoubleIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
2967psql:implicitCasts.sql:769: ERROR:  function structintdoublein(numeric) does not exist
2968LINE 1: SELECT structIntDoubleIn(decimal10_0Val) FROM srcTestTable W...
2969               ^
2970HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2971SELECT structIntDoubleIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
2972psql:implicitCasts.sql:770: ERROR:  function structintdoublein(numeric) does not exist
2973LINE 1: SELECT structIntDoubleIn(decimal10_2Val) FROM srcTestTable W...
2974               ^
2975HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2976SELECT structIntDoubleIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
2977psql:implicitCasts.sql:771: ERROR:  function structintdoublein(numeric) does not exist
2978LINE 1: SELECT structIntDoubleIn(decimal30_15Val) FROM srcTestTable ...
2979               ^
2980HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2981SELECT structIntDoubleIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
2982psql:implicitCasts.sql:772: ERROR:  column "decimal14_7in" does not exist
2983LINE 1: SELECT structIntDoubleIn(decimal14_7In) FROM srcTestTable WH...
2984                                 ^
2985HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
2986SELECT structIntDoubleIn(binaryVal) FROM srcTestTable LIMIT 1;
2987psql:implicitCasts.sql:773: ERROR:  function structintdoublein(bytea) does not exist
2988LINE 1: SELECT structIntDoubleIn(binaryVal) FROM srcTestTable LIMIT ...
2989               ^
2990HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2991SELECT structIntDoubleIn(booleanVal) FROM srcTestTable LIMIT 1;
2992psql:implicitCasts.sql:774: ERROR:  function structintdoublein(boolean) does not exist
2993LINE 1: SELECT structIntDoubleIn(booleanVal) FROM srcTestTable LIMIT...
2994               ^
2995HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2996SELECT structIntDoubleIn(stringVal) FROM srcTestTable LIMIT 1;
2997psql:implicitCasts.sql:775: ERROR:  function structintdoublein(text) does not exist
2998LINE 1: SELECT structIntDoubleIn(stringVal) FROM srcTestTable LIMIT ...
2999               ^
3000HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3001SELECT structIntDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
3002psql:implicitCasts.sql:776: ERROR:  function structintdoublein(date) does not exist
3003LINE 1: SELECT structIntDoubleIn(dateVal) FROM srcTestTable LIMIT 1;
3004               ^
3005HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3006SELECT structIntDoubleIn(timestampVal) FROM srcTestTable LIMIT 1;
3007psql:implicitCasts.sql:777: ERROR:  function structintdoublein(timestamp without time zone) does not exist
3008LINE 1: SELECT structIntDoubleIn(timestampVal) FROM srcTestTable LIM...
3009               ^
3010HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3011SELECT structIntDoubleIn(arrayIntVal) FROM srcTestTable LIMIT 1;
3012psql:implicitCasts.sql:778: ERROR:  function structintdoublein(integer[]) does not exist
3013LINE 1: SELECT structIntDoubleIn(arrayIntVal) FROM srcTestTable LIMI...
3014               ^
3015HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3016SELECT structIntDoubleIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
3017psql:implicitCasts.sql:779: ERROR:  function structintdoublein(double precision[]) does not exist
3018LINE 1: SELECT structIntDoubleIn(arrayDoubleVal) FROM srcTestTable L...
3019               ^
3020HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3021SELECT structIntDoubleIn(structStringIntVal) FROM srcTestTable LIMIT 1;
3022psql:implicitCasts.sql:780: ERROR:  function structintdoublein(structstringintty) does not exist
3023LINE 1: SELECT structIntDoubleIn(structStringIntVal) FROM srcTestTab...
3024               ^
3025HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3026SELECT structIntDoubleIn(null);
3027 structintdoublein 
3028-------------------
3029 NULL
3030(1 row)
3031
3032-- from * to structStringIntTy
3033DROP FUNCTION IF EXISTS structStringIntIn;
3034DROP FUNCTION
3035CREATE FUNCTION structStringIntIn(structStringIntTy) RETURNS structStringIntTy
3036  AS 'select $1;'
3037  LANGUAGE SQL
3038  IMMUTABLE
3039  RETURNS NULL ON NULL INPUT;
3040CREATE FUNCTION
3041SELECT structStringIntIn(shortVal) FROM srcTestTable WHERE shortVal = 1;
3042psql:implicitCasts.sql:791: ERROR:  function structstringintin(smallint) does not exist
3043LINE 1: SELECT structStringIntIn(shortVal) FROM srcTestTable WHERE s...
3044               ^
3045HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3046SELECT structStringIntIn(intVal) FROM srcTestTable WHERE intVal = 1;
3047psql:implicitCasts.sql:792: ERROR:  function structstringintin(integer) does not exist
3048LINE 1: SELECT structStringIntIn(intVal) FROM srcTestTable WHERE int...
3049               ^
3050HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3051SELECT structStringIntIn(longVal) FROM srcTestTable WHERE longVal = 1;
3052psql:implicitCasts.sql:793: ERROR:  function structstringintin(bigint) does not exist
3053LINE 1: SELECT structStringIntIn(longVal) FROM srcTestTable WHERE lo...
3054               ^
3055HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3056SELECT structStringIntIn(doubleVal) FROM srcTestTable WHERE doubleVal < 1.1;
3057psql:implicitCasts.sql:794: ERROR:  function structstringintin(double precision) does not exist
3058LINE 1: SELECT structStringIntIn(doubleVal) FROM srcTestTable WHERE ...
3059               ^
3060HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3061SELECT structStringIntIn(floatVal) FROM srcTestTable WHERE floatVal< 1.1;
3062psql:implicitCasts.sql:795: ERROR:  function structstringintin(real) does not exist
3063LINE 1: SELECT structStringIntIn(floatVal) FROM srcTestTable WHERE f...
3064               ^
3065HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3066SELECT structStringIntIn(decimal3_0Val) FROM srcTestTable WHERE decimal3_0Val = 1;
3067psql:implicitCasts.sql:796: ERROR:  function structstringintin(numeric) does not exist
3068LINE 1: SELECT structStringIntIn(decimal3_0Val) FROM srcTestTable WH...
3069               ^
3070HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3071SELECT structStringIntIn(decimal5_0Val) FROM srcTestTable WHERE decimal5_0Val = 1;
3072psql:implicitCasts.sql:797: ERROR:  function structstringintin(numeric) does not exist
3073LINE 1: SELECT structStringIntIn(decimal5_0Val) FROM srcTestTable WH...
3074               ^
3075HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3076SELECT structStringIntIn(decimal10_0Val) FROM srcTestTable WHERE decimal10_0Val = 1;
3077psql:implicitCasts.sql:798: ERROR:  function structstringintin(numeric) does not exist
3078LINE 1: SELECT structStringIntIn(decimal10_0Val) FROM srcTestTable W...
3079               ^
3080HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3081SELECT structStringIntIn(decimal10_2Val) FROM srcTestTable WHERE decimal10_2Val = 1;
3082psql:implicitCasts.sql:799: ERROR:  function structstringintin(numeric) does not exist
3083LINE 1: SELECT structStringIntIn(decimal10_2Val) FROM srcTestTable W...
3084               ^
3085HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3086SELECT structStringIntIn(decimal30_15Val) FROM srcTestTable WHERE decimal30_15Val = 1;
3087psql:implicitCasts.sql:800: ERROR:  function structstringintin(numeric) does not exist
3088LINE 1: SELECT structStringIntIn(decimal30_15Val) FROM srcTestTable ...
3089               ^
3090HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3091SELECT structStringIntIn(decimal14_7In) FROM srcTestTable WHERE decimal30_15Val = 1;
3092psql:implicitCasts.sql:801: ERROR:  column "decimal14_7in" does not exist
3093LINE 1: SELECT structStringIntIn(decimal14_7In) FROM srcTestTable WH...
3094                                 ^
3095HINT:  Perhaps you meant to reference the column "srctesttable.decimal14_7val".
3096SELECT structStringIntIn(binaryVal) FROM srcTestTable LIMIT 1;
3097psql:implicitCasts.sql:802: ERROR:  function structstringintin(bytea) does not exist
3098LINE 1: SELECT structStringIntIn(binaryVal) FROM srcTestTable LIMIT ...
3099               ^
3100HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3101SELECT structStringIntIn(booleanVal) FROM srcTestTable LIMIT 1;
3102psql:implicitCasts.sql:803: ERROR:  function structstringintin(boolean) does not exist
3103LINE 1: SELECT structStringIntIn(booleanVal) FROM srcTestTable LIMIT...
3104               ^
3105HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3106SELECT structStringIntIn(stringVal) FROM srcTestTable LIMIT 1;
3107psql:implicitCasts.sql:804: ERROR:  function structstringintin(text) does not exist
3108LINE 1: SELECT structStringIntIn(stringVal) FROM srcTestTable LIMIT ...
3109               ^
3110HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3111SELECT structStringIntIn(dateVal) FROM srcTestTable LIMIT 1;
3112psql:implicitCasts.sql:805: ERROR:  function structstringintin(date) does not exist
3113LINE 1: SELECT structStringIntIn(dateVal) FROM srcTestTable LIMIT 1;
3114               ^
3115HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3116SELECT structStringIntIn(timestampVal) FROM srcTestTable LIMIT 1;
3117psql:implicitCasts.sql:806: ERROR:  function structstringintin(timestamp without time zone) does not exist
3118LINE 1: SELECT structStringIntIn(timestampVal) FROM srcTestTable LIM...
3119               ^
3120HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3121SELECT structStringIntIn(arrayIntVal) FROM srcTestTable LIMIT 1;
3122psql:implicitCasts.sql:807: ERROR:  function structstringintin(integer[]) does not exist
3123LINE 1: SELECT structStringIntIn(arrayIntVal) FROM srcTestTable LIMI...
3124               ^
3125HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3126SELECT structStringIntIn(arrayDoubleVal) FROM srcTestTable LIMIT 1;
3127psql:implicitCasts.sql:808: ERROR:  function structstringintin(double precision[]) does not exist
3128LINE 1: SELECT structStringIntIn(arrayDoubleVal) FROM srcTestTable L...
3129               ^
3130HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3131SELECT structStringIntIn(structIntDoubleVal) FROM srcTestTable LIMIT 1;
3132psql:implicitCasts.sql:809: ERROR:  function structstringintin(structintdoublety) does not exist
3133LINE 1: SELECT structStringIntIn(structIntDoubleVal) FROM srcTestTab...
3134               ^
3135HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
3136SELECT structStringIntIn(null);
3137 structstringintin 
3138-------------------
3139 NULL
3140(1 row)