aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-09-17 04:27:41 +0000
committerBruce Momjian <bruce@momjian.us>2002-09-17 04:27:41 +0000
commitff9973a8f1f9fb03b02cdcb36ff40f9e140595d6 (patch)
tree8da1e764c19b603f753cfa587343841176cfa063 /src
parentc53bb2759fe6f02334d8e2859c07f58355bd6e81 (diff)
downloadpostgresql-ff9973a8f1f9fb03b02cdcb36ff40f9e140595d6.tar.gz
postgresql-ff9973a8f1f9fb03b02cdcb36ff40f9e140595d6.zip
Remove src/test/regress/sql: plpgsql-nsp-testing.sql per Joe Conway.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/sql/plpgsql-nsp-testing.sql47
1 files changed, 0 insertions, 47 deletions
diff --git a/src/test/regress/sql/plpgsql-nsp-testing.sql b/src/test/regress/sql/plpgsql-nsp-testing.sql
deleted file mode 100644
index 8694b8db649..00000000000
--- a/src/test/regress/sql/plpgsql-nsp-testing.sql
+++ /dev/null
@@ -1,47 +0,0 @@
--- nspname.relname.attname%TYPE
-DROP FUNCTION t();
-CREATE OR REPLACE FUNCTION t() RETURNS TEXT AS '
-DECLARE
- col_name pg_catalog.pg_attribute.attname%TYPE;
-BEGIN
- col_name := ''uga'';
- RETURN col_name;
-END;
-' LANGUAGE 'plpgsql';
-SELECT t();
-
--- nspname.relname%ROWTYPE
-DROP FUNCTION t();
-CREATE OR REPLACE FUNCTION t() RETURNS pg_catalog.pg_attribute AS '
-DECLARE
- rec pg_catalog.pg_attribute%ROWTYPE;
-BEGIN
- SELECT INTO rec * FROM pg_catalog.pg_attribute WHERE attrelid = 1247 AND attname = ''typname'';
- RETURN rec;
-END;
-' LANGUAGE 'plpgsql';
-SELECT * FROM t();
-
--- nspname.relname.attname%TYPE
-DROP FUNCTION t();
-CREATE OR REPLACE FUNCTION t() RETURNS pg_catalog.pg_attribute.attname%TYPE AS '
-DECLARE
- rec pg_catalog.pg_attribute.attname%TYPE;
-BEGIN
- SELECT INTO rec pg_catalog.pg_attribute.attname FROM pg_catalog.pg_attribute WHERE attrelid = 1247 AND attname = ''typname'';
- RETURN rec;
-END;
-' LANGUAGE 'plpgsql';
-SELECT t();
-
--- nspname.relname%ROWTYPE
-DROP FUNCTION t();
-CREATE OR REPLACE FUNCTION t() RETURNS pg_catalog.pg_attribute AS '
-DECLARE
- rec pg_catalog.pg_attribute%ROWTYPE;
-BEGIN
- SELECT INTO rec * FROM pg_catalog.pg_attribute WHERE attrelid = 1247 AND attname = ''typname'';
- RETURN rec;
-END;
-' LANGUAGE 'plpgsql';
-SELECT * FROM t();