From ff9973a8f1f9fb03b02cdcb36ff40f9e140595d6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 17 Sep 2002 04:27:41 +0000 Subject: Remove src/test/regress/sql: plpgsql-nsp-testing.sql per Joe Conway. --- src/test/regress/sql/plpgsql-nsp-testing.sql | 47 ---------------------------- 1 file changed, 47 deletions(-) delete mode 100644 src/test/regress/sql/plpgsql-nsp-testing.sql (limited to 'src') 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(); -- cgit v1.2.3