aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/create_procedure.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/create_procedure.out')
-rw-r--r--src/test/regress/expected/create_procedure.out12
1 files changed, 8 insertions, 4 deletions
diff --git a/src/test/regress/expected/create_procedure.out b/src/test/regress/expected/create_procedure.out
index ccad5c87d5e..873907dc434 100644
--- a/src/test/regress/expected/create_procedure.out
+++ b/src/test/regress/expected/create_procedure.out
@@ -21,6 +21,8 @@ LINE 1: SELECT ptest1('x');
^
HINT: To call a procedure, use CALL.
CALL ptest1('a'); -- ok
+CALL ptest1('xy' || 'zzy'); -- ok, constant-folded arg
+CALL ptest1(substring(random()::text, 1, 1)); -- ok, volatile arg
\df ptest1
List of functions
Schema | Name | Result data type | Argument data types | Type
@@ -28,11 +30,13 @@ CALL ptest1('a'); -- ok
public | ptest1 | | x text | proc
(1 row)
-SELECT * FROM cp_test ORDER BY a;
- a | b
----+---
+SELECT * FROM cp_test ORDER BY b COLLATE "C";
+ a | b
+---+-------
+ 1 | 0
1 | a
-(1 row)
+ 1 | xyzzy
+(3 rows)
CREATE PROCEDURE ptest2()
LANGUAGE SQL