diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-08-06 05:34:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-08-06 05:34:46 +0000 |
| commit | 683b0d3add6afcbfe4484358985aed0deb2d89ac (patch) | |
| tree | 129aca4b91a33cb337721a736e719af734294c41 /src | |
| parent | 4f63e11646dad37f5bb8445d8699f952801b7f8a (diff) | |
| download | postgresql-683b0d3add6afcbfe4484358985aed0deb2d89ac.tar.gz postgresql-683b0d3add6afcbfe4484358985aed0deb2d89ac.zip | |
Of course, the simple change has ripple effects! Here's a patch for the
rangefunc regression test for the new behavior.
Joe Conway
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rangefuncs.out | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/rangefuncs.out b/src/test/regress/expected/rangefuncs.out index f930c857aa6..582859d15a5 100644 --- a/src/test/regress/expected/rangefuncs.out +++ b/src/test/regress/expected/rangefuncs.out @@ -48,9 +48,9 @@ INSERT INTO foo VALUES(2,1,'Mary'); -- sql, proretset = f, prorettype = b CREATE FUNCTION getfoo(int) RETURNS int AS 'SELECT $1;' LANGUAGE SQL; SELECT * FROM getfoo(1) AS t1; - getfoo --------- - 1 + t1 +---- + 1 (1 row) CREATE VIEW vw_getfoo AS SELECT * FROM getfoo(1); @@ -65,10 +65,10 @@ DROP VIEW vw_getfoo; DROP FUNCTION getfoo(int); CREATE FUNCTION getfoo(int) RETURNS setof int AS 'SELECT fooid FROM foo WHERE fooid = $1;' LANGUAGE SQL; SELECT * FROM getfoo(1) AS t1; - getfoo --------- - 1 - 1 + t1 +---- + 1 + 1 (2 rows) CREATE VIEW vw_getfoo AS SELECT * FROM getfoo(1); @@ -84,8 +84,8 @@ DROP VIEW vw_getfoo; DROP FUNCTION getfoo(int); CREATE FUNCTION getfoo(int) RETURNS setof text AS 'SELECT fooname FROM foo WHERE fooid = $1;' LANGUAGE SQL; SELECT * FROM getfoo(1) AS t1; - getfoo --------- + t1 +----- Joe Ed (2 rows) @@ -139,9 +139,9 @@ DROP VIEW vw_getfoo; DROP FUNCTION getfoo(int); 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'; SELECT * FROM getfoo(1) AS t1; - getfoo --------- - 1 + t1 +---- + 1 (1 row) CREATE VIEW vw_getfoo AS SELECT * FROM getfoo(1); |