From 1b42ad7e59e03dbacf880b72cfae4c16e6d3be49 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 14 Dec 2002 00:24:35 +0000 Subject: Initial version of the SQL information schema --- src/test/regress/output/create_function_2.source | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/test/regress/output/create_function_2.source') diff --git a/src/test/regress/output/create_function_2.source b/src/test/regress/output/create_function_2.source index 4d508497cf..58a3c550f6 100644 --- a/src/test/regress/output/create_function_2.source +++ b/src/test/regress/output/create_function_2.source @@ -22,8 +22,9 @@ CREATE FUNCTION equipment(hobbies_r) CREATE FUNCTION user_relns() RETURNS setof name AS 'select relname - from pg_class - where relname !~ ''pg_.*'' and + from pg_class c, pg_namespace n + where relnamespace = n.oid and + (nspname !~ ''pg_.*'' and nspname <> ''information_schema'') and relkind <> ''i'' ' LANGUAGE 'sql'; CREATE FUNCTION pt_in_widget(point, widget) -- cgit v1.2.1