# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

mode cockroach

query TIIOI
SELECT proname, pronamespace, oid, proargdefaults, prorettype
FROM pg_catalog.pg_proc
WHERE proname = 'substring'
ORDER BY oid
----
substring  16657  936  NULL  25
substring  16657  937  NULL  25

query TIIII
SELECT oprname, oid, oprresult, oprleft, oprright
FROM pg_catalog.pg_operator
WHERE oprname = '+'
ORDER BY oid
----
+  550  21  21  21
+  551  23  23  23
+  586  700  700  700
+  591  701  701  701
+  684  20  20  20
+  1076  1114  1082  1186
+  1327  1184  1184  1186
+  1337  1186  1186  1186
+  1360  1114  1082  1083
+  1363  1114  1083  1082
+  1758  1700  1700  1700
+  1800  1083  1083  1186
+  1849  1083  1186  1083
+  2066  1114  1114  1186
+  2551  1114  1186  1082
+  2553  1114  1186  1114
+  2554  1184  1186  1184
+  3898  3831  3831  3831
+  16433  2276  0  2276
+  16466  16460  16460  16460
+  16467  16462  16462  16462
+  16468  16464  16464  16464