summaryrefslogtreecommitdiff
path: root/contrib/intarray/expected
diff options
context:
space:
mode:
authorAndrew Dunstan2022-12-28 14:53:00 +0000
committerAndrew Dunstan2022-12-28 15:00:12 +0000
commit3b76622e04d8656fb44e7c932cb243e2d92fe40e (patch)
tree6840be0512c688b2e92d43b6138fee7465d7030f /contrib/intarray/expected
parent24b55cd949a11b712927acf2557683976ee149ac (diff)
Convert contrib/intarray's bqarr_in() to report errors softly
Reviewed by Tom Lane and Amul Sul Discussion: https://postgr.es/m/49e598c2-cfe8-0928-b6fb-d0cc51aab626@dunslane.net
Diffstat (limited to 'contrib/intarray/expected')
-rw-r--r--contrib/intarray/expected/_int.out15
1 files changed, 15 insertions, 0 deletions
diff --git a/contrib/intarray/expected/_int.out b/contrib/intarray/expected/_int.out
index a09d40efa17..c953065a5c0 100644
--- a/contrib/intarray/expected/_int.out
+++ b/contrib/intarray/expected/_int.out
@@ -398,6 +398,21 @@ SELECT '1&(2&(4&(5|!6)))'::query_int;
1 & 2 & 4 & ( 5 | !6 )
(1 row)
+-- test non-error-throwing input
+SELECT str as "query_int",
+ pg_input_is_valid(str,'query_int') as ok,
+ pg_input_error_message(str,'query_int') as errmsg
+FROM (VALUES ('1&(2&(4&(5|6)))'),
+ ('1#(2&(4&(5&6)))'),
+ ('foo'))
+ AS a(str);
+ query_int | ok | errmsg
+-----------------+----+--------------
+ 1&(2&(4&(5|6))) | t |
+ 1#(2&(4&(5&6))) | f | syntax error
+ foo | f | syntax error
+(3 rows)
+
CREATE TABLE test__int( a int[] );
\copy test__int from 'data/test__int.data'
ANALYZE test__int;