diff options
author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-02-11 03:51:38 +0000 |
---|---|---|
committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-02-11 03:51:38 +0000 |
commit | 9e22f82562a5641c4631652be59cfce69246734c (patch) | |
tree | da5780fa2b023938a6118ebc9cc0e56f29bfae44 /src/tutorial/funcs.source | |
parent | 1f4f6b22bce701af8a5d2af0ca4a3b0dc7151591 (diff) | |
download | postgresql-9e22f82562a5641c4631652be59cfce69246734c.tar.gz postgresql-9e22f82562a5641c4631652be59cfce69246734c.zip |
Fix typos in SQL statement terminators.
Diffstat (limited to 'src/tutorial/funcs.source')
-rw-r--r-- | src/tutorial/funcs.source | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/src/tutorial/funcs.source b/src/tutorial/funcs.source index 00f256ea859..f2306839246 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.1.1.1 1996/07/09 06:22:34 scrappy Exp $ +-- $Id: funcs.source,v 1.2 1998/02/11 03:51:38 thomas Exp $ -- --------------------------------------------------------------------------- @@ -55,10 +55,10 @@ CREATE TABLE EMP ( dept char16 ); -INSERT INTO EMP VALUES ('Sam', 1200, 16, 'toy') -INSERT INTO EMP VALUES ('Claire', 5000, 32, 'shoe') -INSERT INTO EMP VALUES ('Andy', -1000, 2, 'candy') -INSERT INTO EMP VALUES ('Bill', 4200, 36, 'shoe') +INSERT INTO EMP VALUES ('Sam', 1200, 16, 'toy'); +INSERT INTO EMP VALUES ('Claire', 5000, 32, 'shoe'); +INSERT INTO EMP VALUES ('Andy', -1000, 2, 'candy'); +INSERT INTO EMP VALUES ('Bill', 4200, 36, 'shoe'); INSERT INTO EMP VALUES ('Ginger', 4800, 30, 'candy'); -- the argument of a function can also be a tuple. For instance, @@ -107,7 +107,7 @@ SELECT name(high_pay()) AS overpaid; SELECT * FROM EMP; CREATE FUNCTION clean_EMP () RETURNS int4 - AS 'DELETE FROM EMP WHERE EMP.salary <= 0 + AS 'DELETE FROM EMP WHERE EMP.salary <= 0\; SELECT 1 AS ignore_this' LANGUAGE 'sql'; @@ -146,13 +146,13 @@ WHERE name = 'Bill' or name = 'Sam'; -- remove functions that were created in this file -DROP FUNCTION c_overpaid(EMP, int4) -DROP FUNCTION copytext(text) -DROP FUNCTION concat16(char16,char16) -DROP FUNCTION add_one(int4) -DROP FUNCTION clean_EMP() -DROP FUNCTION new_emp() -DROP FUNCTION add_em(int4, int4) +DROP FUNCTION c_overpaid(EMP, int4); +DROP FUNCTION copytext(text); +DROP FUNCTION concat16(char16,char16); +DROP FUNCTION add_one(int4); +DROP FUNCTION clean_EMP(); +DROP FUNCTION new_emp(); +DROP FUNCTION add_em(int4, int4); DROP FUNCTION one(); DROP TABLE EMP; |