diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-10-26 04:51:51 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-10-26 04:51:51 +0000 |
| commit | 3c9a32d4a277771e15b7d8a7ee83b0aab329a33d (patch) | |
| tree | ddbf7afb29577288dc86bc8d0353442004ce99ae /src/tutorial/funcs.source | |
| parent | b3a10a88d7c5855a16e8e6d20813d355471b4cd1 (diff) | |
| download | postgresql-3c9a32d4a277771e15b7d8a7ee83b0aab329a33d.tar.gz postgresql-3c9a32d4a277771e15b7d8a7ee83b0aab329a33d.zip | |
Fix two bugs in funcs.source that made the tutorial script fail.
Make a LOT of fixes to syscat.source to:
* Set search_path properly (and reset it)
* Add schema name to all results
* Add schema name to ORDER BY first
* Make checks for user-defined objects match reality
* format_type all type names
* Respect attisdropped
* Change !~ to 'not like' since it's more standard
Christopher Kings-Lynne
Diffstat (limited to 'src/tutorial/funcs.source')
| -rw-r--r-- | src/tutorial/funcs.source | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/tutorial/funcs.source b/src/tutorial/funcs.source index 8438e6daece..4685907b864 100644 --- a/src/tutorial/funcs.source +++ b/src/tutorial/funcs.source @@ -6,7 +6,7 @@ -- -- Copyright (c) 1994-5, Regents of the University of California -- --- $Id: funcs.source,v 1.5 2001/10/26 20:45:33 tgl Exp $ +-- $Id: funcs.source,v 1.6 2003/10/26 04:51:51 momjian Exp $ -- --------------------------------------------------------------------------- @@ -153,10 +153,11 @@ DROP FUNCTION c_overpaid(EMP, int4); DROP FUNCTION copytext(text); DROP FUNCTION makepoint(point,point); DROP FUNCTION add_one(int4); -DROP FUNCTION clean_EMP(); +--DROP FUNCTION clean_EMP(); DROP FUNCTION high_pay(); DROP FUNCTION new_emp(); DROP FUNCTION add_em(int4, int4); DROP FUNCTION one(); +DROP FUNCTION double_salary(EMP); DROP TABLE EMP; |