diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2002-12-14 00:24:35 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2002-12-14 00:24:35 +0000 |
| commit | 1b42ad7e59e03dbacf880b72cfae4c16e6d3be49 (patch) | |
| tree | 00783d7ceaa48f634f0c533ad6b2df7e1721b3cc /src/test/regress/input/create_function_2.source | |
| parent | 2d8d66628a8ac49deba8483608135b3c358ae729 (diff) | |
| download | postgresql-1b42ad7e59e03dbacf880b72cfae4c16e6d3be49.tar.gz | |
Initial version of the SQL information schema
Diffstat (limited to 'src/test/regress/input/create_function_2.source')
| -rw-r--r-- | src/test/regress/input/create_function_2.source | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/test/regress/input/create_function_2.source b/src/test/regress/input/create_function_2.source index 4bcf24c601..07d26c1d8f 100644 --- a/src/test/regress/input/create_function_2.source +++ b/src/test/regress/input/create_function_2.source @@ -28,8 +28,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'; |