You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: src/test/regress/expected/rangefuncs.out
+12-12Lines changed: 12 additions & 12 deletions
Original file line number
Diff line number
Diff line change
@@ -48,9 +48,9 @@ INSERT INTO foo VALUES(2,1,'Mary');
48
48
-- sql, proretset = f, prorettype = b
49
49
CREATE FUNCTION getfoo(int) RETURNS int AS 'SELECT $1;' LANGUAGE SQL;
50
50
SELECT * FROM getfoo(1) AS t1;
51
-
getfoo
52
-
--------
53
-
1
51
+
t1
52
+
----
53
+
1
54
54
(1 row)
55
55
56
56
CREATE VIEW vw_getfoo AS SELECT * FROM getfoo(1);
@@ -65,10 +65,10 @@ DROP VIEW vw_getfoo;
65
65
DROP FUNCTION getfoo(int);
66
66
CREATE FUNCTION getfoo(int) RETURNS setof int AS 'SELECT fooid FROM foo WHERE fooid = $1;' LANGUAGE SQL;
67
67
SELECT * FROM getfoo(1) AS t1;
68
-
getfoo
69
-
--------
70
-
1
71
-
1
68
+
t1
69
+
----
70
+
1
71
+
1
72
72
(2 rows)
73
73
74
74
CREATE VIEW vw_getfoo AS SELECT * FROM getfoo(1);
@@ -84,8 +84,8 @@ DROP VIEW vw_getfoo;
84
84
DROP FUNCTION getfoo(int);
85
85
CREATE FUNCTION getfoo(int) RETURNS setof text AS 'SELECT fooname FROM foo WHERE fooid = $1;' LANGUAGE SQL;
86
86
SELECT * FROM getfoo(1) AS t1;
87
-
getfoo
88
-
--------
87
+
t1
88
+
-----
89
89
Joe
90
90
Ed
91
91
(2 rows)
@@ -139,9 +139,9 @@ DROP VIEW vw_getfoo;
139
139
DROP FUNCTION getfoo(int);
140
140
CREATE FUNCTION getfoo(int) RETURNS int AS 'DECLARE fooint int; BEGIN SELECT fooid into fooint FROM foo WHERE fooid = $1; RETURN fooint; END;' LANGUAGE 'plpgsql';