blob: 246736b008a61b79b04920bc64e1cd6a9294befb (plain)

ofs	hex dump	ascii
0000	99 4e 0d 0a e2 64 a1 34 63 00 00 00 00 01 00 00 00 73 97 00 00 00 7f 00 00 7f 05 00 64 00 00 47	.N...d.4c........s..........d..G
0020	48 7f 06 00 64 01 00 47 48 7f 07 00 48 7f 08 00 64 02 00 47 48 7f 09 00 48 7f 0a 00 64 03 00 47	H...d..GH...H...d..GH...H...d..G
0040	48 7f 0b 00 64 04 00 47 48 7f 0c 00 64 05 00 47 48 7f 0d 00 64 00 00 47 48 7f 0f 00 6b 00 00 6c	H...d..GH...d..GH...d..GH...k..l
0060	01 00 01 7f 10 00 6b 02 00 6c 01 00 01 7f 13 00 64 06 00 84 00 00 5a 03 00 7f 3c 00 64 07 00 84	......k..l......d.....Z...<.d...
0080	00 00 5a 04 00 7f 95 00 64 08 00 84 00 00 5a 05 00 7f b3 00 64 09 00 84 00 00 5a 06 00 7f c5 00	..Z.....d.....Z.....d.....Z.....
00a0	64 0a 00 84 00 00 5a 07 00 64 0b 00 53 28 0c 00 00 00 73 42 00 00 00 5f 5f 5f 5f 5f 5f 5f 5f 5f	d.....Z..d..S(....sB..._________
00c0	5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f	________________________________
00e0	5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 73 31 00 00 00 4d 4f	_________________________s1...MO
0100	44 55 4c 45 20 46 55 4e 43 2e 50 59 20 3a 20 53 51 4c 20 46 55 4e 43 54 49 4f 4e 20 44 45 46 49	DULE.FUNC.PY.:.SQL.FUNCTION.DEFI
0120	4e 49 54 49 4f 4e 20 54 55 54 4f 52 49 41 4c 73 3d 00 00 00 54 68 69 73 20 6d 6f 64 75 6c 65 20	NITION.TUTORIALs=...This.module.
0140	69 73 20 64 65 73 69 67 6e 65 64 20 66 6f 72 20 62 65 69 6e 67 20 69 6d 70 6f 72 74 65 64 20 66	is.designed.for.being.imported.f
0160	72 6f 6d 20 70 79 74 68 6f 6e 20 70 72 6f 6d 70 74 73 44 00 00 00 49 6e 20 6f 72 64 65 72 20 74	rom.python.promptsD...In.order.t
0180	6f 20 72 75 6e 20 74 68 65 20 73 61 6d 70 6c 65 73 20 69 6e 63 6c 75 64 65 64 20 68 65 72 65 2c	o.run.the.samples.included.here,
01a0	20 66 69 72 73 74 20 63 72 65 61 74 65 20 61 20 63 6f 6e 6e 65 63 74 69 6f 6e 73 36 00 00 00 75	.first.create.a.connections6...u
01c0	73 69 6e 67 20 3a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 63 6e	sing.:........................cn
01e0	78 20 3d 20 66 75 6e 63 2e 63 6f 6e 6e 65 63 74 28 2e 2e 2e 29 73 2d 00 00 00 74 68 65 6e 20 73	x.=.func.connect(...)s-...then.s
0200	74 61 72 74 20 74 68 65 20 64 65 6d 6f 20 77 69 74 68 3a 20 20 20 20 20 20 66 75 6e 63 2e 64 65	tart.the.demo.with:......func.de
0220	6d 6f 28 63 6e 78 29 63 01 00 02 00 03 00 03 00 73 59 01 00 00 7f 13 00 7f 14 00 64 01 00 47 48	mo(cnx)c........sY.........d..GH
0240	7f 15 00 64 02 00 47 48 7f 16 00 64 03 00 47 48 7f 17 00 64 04 00 47 48 7f 18 00 64 05 00 47 48	...d..GH...d..GH...d..GH...d..GH
0260	7f 19 00 64 06 00 47 48 7f 1a 00 64 01 00 47 48 7f 1b 00 48 7f 1c 00 64 07 00 47 48 7f 1d 00 64	...d..GH...d..GH...H...d..GH...d
0280	08 00 47 48 7f 1e 00 64 09 00 47 48 7f 1f 00 48 7f 20 00 64 0a 00 47 48 7f 21 00 64 0b 00 47 48	..GH...d..GH...H...d..GH.!.d..GH
02a0	7f 22 00 7c 00 00 69 01 00 64 0c 00 83 01 00 01 7f 24 00 74 02 00 83 00 00 01 7f 25 00 48 7f 26	.".|..i..d.......$.t.......%.H.&
02c0	00 64 07 00 47 48 7f 27 00 64 0d 00 47 48 7f 28 00 64 0e 00 47 48 7f 29 00 48 7f 2a 00 64 0f 00	.d..GH.'.d..GH.(.d..GH.).H.*.d..
02e0	47 48 7f 2b 00 7c 00 00 69 01 00 64 0f 00 83 01 00 7d 01 00 7f 2c 00 74 04 00 7c 01 00 69 05 00	GH.+.|..i..d.....}...,.t..|..i..
0300	83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f 2d 00 48 7f 2e 00 64 07 00 47 48 7f 2f 00 64	...|..i..........-.H...d..GH./.d
0320	10 00 47 48 7f 30 00 64 11 00 47 48 7f 31 00 48 7f 32 00 64 12 00 47 48 7f 33 00 64 13 00 47 48	..GH.0.d..GH.1.H.2.d..GH.3.d..GH
0340	7f 34 00 7c 00 00 69 01 00 64 14 00 83 01 00 01 7f 36 00 48 7f 37 00 64 15 00 47 48 7f 38 00 7c	.4.|..i..d.......6.H.7.d..GH.8.|
0360	00 00 69 01 00 64 15 00 83 01 00 7d 01 00 7f 39 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00	..i..d.....}...9.t..|..i.....|..
0380	69 06 00 83 00 00 83 02 00 01 64 00 00 53 28 16 00 00 00 4e 73 1d 00 00 00 2d 2d 2d 2d 2d 2d 2d	i.........d..S(....Ns....-------
03a0	2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 73 27 00 00 00 2d 2d 20 43 72	----------------------s'...--.Cr
03c0	65 61 74 69 6e 67 20 53 51 4c 20 46 75 6e 63 74 69 6f 6e 73 20 6f 6e 20 42 61 73 65 20 54 79 70	eating.SQL.Functions.on.Base.Typ
03e0	65 73 73 35 00 00 00 2d 2d 09 61 20 43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20 73 74 61 74	ess5...--.a.CREATE.FUNCTION.stat
0400	65 6d 65 6e 74 20 6c 65 74 73 20 79 6f 75 20 63 72 65 61 74 65 20 61 20 6e 65 77 20 73 38 00 00	ement.lets.you.create.a.new.s8..
0420	00 2d 2d 09 66 75 6e 63 74 69 6f 6e 20 74 68 61 74 20 63 61 6e 20 62 65 20 75 73 65 64 20 69 6e	.--.function.that.can.be.used.in
0440	20 65 78 70 72 65 73 73 69 6f 6e 73 20 28 69 6e 20 53 45 4c 45 43 54 2c 20 73 34 00 00 00 2d 2d	.expressions.(in.SELECT,.s4...--
0460	09 49 4e 53 45 52 54 2c 20 65 74 63 2e 29 2e 20 57 65 20 77 69 6c 6c 20 73 74 61 72 74 20 77 69	.INSERT,.etc.)..We.will.start.wi
0480	74 68 20 66 75 6e 63 74 69 6f 6e 73 20 74 68 61 74 20 73 1f 00 00 00 2d 2d 09 72 65 74 75 72 6e	th.functions.that.s....--.return
04a0	20 76 61 6c 75 65 73 20 6f 66 20 62 61 73 65 20 74 79 70 65 73 2e 73 02 00 00 00 2d 2d 73 3d 00	.values.of.base.types.s....--s=.
04c0	00 00 2d 2d 20 6c 65 74 27 73 20 63 72 65 61 74 65 20 61 20 73 69 6d 70 6c 65 20 53 51 4c 20 66	..--.let's.create.a.simple.SQL.f
04e0	75 6e 63 74 69 6f 6e 20 74 68 61 74 20 74 61 6b 65 73 20 6e 6f 20 61 72 67 75 6d 65 6e 74 73 73	unction.that.takes.no.argumentss
0500	10 00 00 00 2d 2d 20 61 6e 64 20 72 65 74 75 72 6e 73 20 31 73 22 00 00 00 43 52 45 41 54 45 20	....--.and.returns.1s"...CREATE.
0520	46 55 4e 43 54 49 4f 4e 20 6f 6e 65 28 29 20 52 45 54 55 52 4e 53 20 69 6e 74 34 73 26 00 00 00	FUNCTION.one().RETURNS.int4s&...
0540	20 20 20 41 53 20 27 53 45 4c 45 43 54 20 31 20 61 73 20 4f 4e 45 27 20 4c 41 4e 47 55 41 47 45	...AS.'SELECT.1.as.ONE'.LANGUAGE
0560	20 27 73 71 6c 27 73 46 00 00 00 43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20 6f 6e 65 28 29	.'sql'sF...CREATE.FUNCTION.one()
0580	20 52 45 54 55 52 4e 53 20 69 6e 74 34 20 41 53 20 27 53 45 4c 45 43 54 20 31 20 61 73 20 4f 4e	.RETURNS.int4.AS.'SELECT.1.as.ON
05a0	45 27 20 4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 3e 00 00 00 2d 2d 20 66 75 6e 63 74 69 6f	E'.LANGUAGE.'sql's>...--.functio
05c0	6e 73 20 63 61 6e 20 62 65 20 75 73 65 64 20 69 6e 20 61 6e 79 20 65 78 70 72 65 73 73 69 6f 6e	ns.can.be.used.in.any.expression
05e0	73 20 28 65 67 2e 20 69 6e 20 74 68 65 20 74 61 72 67 65 74 73 1a 00 00 00 2d 2d 20 6c 69 73 74	s.(eg..in.the.targets....--.list
0600	20 6f 72 20 71 75 61 6c 69 66 69 63 61 74 69 6f 6e 73 29 73 16 00 00 00 53 45 4c 45 43 54 20 6f	.or.qualifications)s....SELECT.o
0620	6e 65 28 29 20 41 53 20 61 6e 73 77 65 72 73 3d 00 00 00 2d 2d 20 68 65 72 65 27 73 20 68 6f 77	ne().AS.answers=...--.here's.how
0640	20 79 6f 75 20 63 72 65 61 74 65 20 61 20 66 75 6e 63 74 69 6f 6e 20 74 68 61 74 20 74 61 6b 65	.you.create.a.function.that.take
0660	73 20 61 72 67 75 6d 65 6e 74 73 2e 20 54 68 65 73 3b 00 00 00 2d 2d 20 66 6f 6c 6c 6f 77 69 6e	s.arguments..Thes;...--.followin
0680	67 20 66 75 6e 63 74 69 6f 6e 20 72 65 74 75 72 6e 73 20 74 68 65 20 73 75 6d 20 6f 66 20 69 74	g.function.returns.the.sum.of.it
06a0	73 20 74 77 6f 20 61 72 67 75 6d 65 6e 74 73 3a 73 2f 00 00 00 43 52 45 41 54 45 20 46 55 4e 43	s.two.arguments:s/...CREATE.FUNC
06c0	54 49 4f 4e 20 61 64 64 5f 65 6d 28 69 6e 74 34 2c 20 69 6e 74 34 29 20 52 45 54 55 52 4e 53 20	TION.add_em(int4,.int4).RETURNS.
06e0	69 6e 74 34 73 25 00 00 00 20 20 20 41 53 20 27 53 45 4c 45 43 54 20 24 31 20 2b 20 24 32 27 20	int4s%......AS.'SELECT.$1.+.$2'.
0700	4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 52 00 00 00 43 52 45 41 54 45 20 46 55 4e 43 54 49	LANGUAGE.'sql'sR...CREATE.FUNCTI
0720	4f 4e 20 61 64 64 5f 65 6d 28 69 6e 74 34 2c 20 69 6e 74 34 29 20 52 45 54 55 52 4e 53 20 69 6e	ON.add_em(int4,.int4).RETURNS.in
0740	74 34 20 41 53 20 27 53 45 4c 45 43 54 20 24 31 20 2b 20 24 32 27 20 4c 41 4e 47 55 41 47 45 20	t4.AS.'SELECT.$1.+.$2'.LANGUAGE.
0760	27 73 71 6c 27 73 1d 00 00 00 53 45 4c 45 43 54 20 61 64 64 5f 65 6d 28 31 2c 20 32 29 20 41 53	'sql's....SELECT.add_em(1,.2).AS
0780	20 61 6e 73 77 65 72 28 07 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79	.answer(....s....pgcnxs....query
07a0	73 08 00 00 00 77 61 69 74 5f 6b 65 79 73 01 00 00 00 71 73 07 00 00 00 64 69 73 70 6c 61 79 73	s....wait_keys....qs....displays
07c0	0a 00 00 00 6c 69 73 74 66 69 65 6c 64 73 73 09 00 00 00 67 65 74 72 65 73 75 6c 74 28 02 00 00	....listfieldss....getresult(...
07e0	00 73 05 00 00 00 70 67 63 6e 78 73 01 00 00 00 71 73 07 00 00 00 66 75 6e 63 2e 70 79 73 09 00	.s....pgcnxs....qs....func.pys..
0800	00 00 62 61 73 65 5f 66 75 6e 63 13 00 73 48 00 00 00 03 01 08 01 08 01 08 01 08 01 08 01 08 01	..base_func..sH.................
0820	08 01 04 01 08 01 08 01 08 01 04 01 08 01 08 01 10 02 0a 01 04 01 08 01 08 01 08 01 04 01 08 01	................................
0840	12 01 1c 01 04 01 08 01 08 01 08 01 04 01 08 01 08 01 10 02 04 01 08 01 12 01 63 01 00 02 00 03	..........................c.....
0860	00 03 00 73 c5 02 00 00 7f 3c 00 7f 3d 00 64 01 00 47 48 7f 3e 00 64 02 00 47 48 7f 3f 00 64 03	...s.....<..=.d..GH.>.d..GH.?.d.
0880	00 47 48 7f 40 00 64 04 00 47 48 7f 41 00 64 01 00 47 48 7f 42 00 48 7f 43 00 64 05 00 47 48 7f	.GH.@.d..GH.A.d..GH.B.H.C.d..GH.
08a0	44 00 64 06 00 47 48 7f 45 00 48 7f 46 00 64 07 00 47 48 7f 47 00 64 08 00 47 48 7f 48 00 64 09	D.d..GH.E.H.F.d..GH.G.d..GH.H.d.
08c0	00 47 48 7f 49 00 64 0a 00 47 48 7f 4a 00 64 0b 00 47 48 7f 4b 00 64 0c 00 47 48 7f 4c 00 7c 00	.GH.I.d..GH.J.d..GH.K.d..GH.L.|.
08e0	00 69 01 00 64 0d 00 83 01 00 01 7f 51 00 48 7f 52 00 64 0e 00 47 48 7f 53 00 64 0f 00 47 48 7f	.i..d.......Q.H.R.d..GH.S.d..GH.
0900	54 00 64 10 00 47 48 7f 55 00 64 11 00 47 48 7f 56 00 64 12 00 47 48 7f 57 00 7c 00 00 69 01 00	T.d..GH.U.d..GH.V.d..GH.W.|..i..
0920	64 0e 00 83 01 00 01 7f 58 00 7c 00 00 69 01 00 64 0f 00 83 01 00 01 7f 59 00 7c 00 00 69 01 00	d.......X.|..i..d.......Y.|..i..
0940	64 10 00 83 01 00 01 7f 5a 00 7c 00 00 69 01 00 64 11 00 83 01 00 01 7f 5b 00 7c 00 00 69 01 00	d.......Z.|..i..d.......[.|..i..
0960	64 12 00 83 01 00 01 7f 5c 00 74 02 00 83 00 00 01 7f 5d 00 48 7f 5e 00 64 13 00 47 48 7f 5f 00	d.......\.t.......].H.^.d..GH._.
0980	64 14 00 47 48 7f 60 00 48 7f 61 00 64 15 00 47 48 7f 62 00 64 16 00 47 48 7f 63 00 7c 00 00 69	d..GH.`.H.a.d..GH.b.d..GH.c.|..i
09a0	01 00 64 17 00 83 01 00 01 7f 65 00 48 7f 66 00 64 18 00 47 48 7f 67 00 64 19 00 47 48 7f 68 00	..d.......e.H.f.d..GH.g.d..GH.h.
09c0	64 1a 00 47 48 7f 69 00 7c 00 00 69 01 00 64 1b 00 83 01 00 7d 01 00 7f 6b 00 74 04 00 7c 01 00	d..GH.i.|..i..d.....}...k.t..|..
09e0	69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f 6c 00 48 7f 6d 00 64 1c 00 47 48 7f	i.....|..i..........l.H.m.d..GH.
0a00	6e 00 64 1d 00 47 48 7f 6f 00 64 1e 00 47 48 7f 70 00 48 7f 71 00 64 1f 00 47 48 7f 72 00 64 20	n.d..GH.o.d..GH.p.H.q.d..GH.r.d.
0a20	00 47 48 7f 73 00 64 21 00 47 48 7f 74 00 64 22 00 47 48 7f 75 00 64 23 00 47 48 7f 76 00 64 24	.GH.s.d!.GH.t.d".GH.u.d#.GH.v.d$
0a40	00 47 48 7f 77 00 7c 00 00 69 01 00 64 25 00 83 01 00 01 7f 7d 00 74 02 00 83 00 00 01 7f 7e 00	.GH.w.|..i..d%......}.t.......~.
0a60	48 7f 7f 00 64 26 00 47 48 7f 80 00 64 27 00 47 48 7f 81 00 64 28 00 47 48 7f 82 00 64 29 00 47	H...d&.GH...d'.GH...d(.GH...d).G
0a80	48 7f 83 00 48 7f 84 00 64 2a 00 47 48 7f 85 00 7c 00 00 69 01 00 64 2a 00 83 01 00 7d 01 00 7f	H...H...d*.GH...|..i..d*....}...
0aa0	86 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f 87 00 48 7f	..t..|..i.....|..i............H.
0ac0	88 00 64 2b 00 47 48 7f 89 00 64 2c 00 47 48 7f 8a 00 64 2d 00 47 48 7f 8b 00 64 24 00 47 48 7f	..d+.GH...d,.GH...d-.GH...d$.GH.
0ae0	8c 00 7c 00 00 69 01 00 64 2e 00 83 01 00 01 7f 8f 00 48 7f 90 00 64 2f 00 47 48 7f 91 00 7c 00	..|..i..d.........H...d/.GH...|.
0b00	00 69 01 00 64 2f 00 83 01 00 7d 01 00 7f 92 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69	.i..d/....}.....t..|..i.....|..i
0b20	06 00 83 00 00 83 02 00 01 64 00 00 53 28 30 00 00 00 4e 73 1d 00 00 00 2d 2d 2d 2d 2d 2d 2d 2d	.........d..S(0...Ns....--------
0b40	2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 73 2c 00 00 00 2d 2d 20 43 72 65	---------------------s,...--.Cre
0b60	61 74 69 6e 67 20 53 51 4c 20 46 75 6e 63 74 69 6f 6e 73 20 6f 6e 20 43 6f 6d 70 6f 73 69 74 65	ating.SQL.Functions.on.Composite
0b80	20 54 79 70 65 73 73 36 00 00 00 2d 2d 09 69 74 20 69 73 20 61 6c 73 6f 20 70 6f 73 73 69 62 6c	.Typess6...--.it.is.also.possibl
0ba0	65 20 74 6f 20 63 72 65 61 74 65 20 66 75 6e 63 74 69 6f 6e 73 20 74 68 61 74 20 72 65 74 75 72	e.to.create.functions.that.retur
0bc0	6e 73 1d 00 00 00 2d 2d 09 76 61 6c 75 65 73 20 6f 66 20 63 6f 6d 70 6f 73 69 74 65 20 74 79 70	ns....--.values.of.composite.typ
0be0	65 73 2e 73 38 00 00 00 2d 2d 20 62 65 66 6f 72 65 20 77 65 20 63 72 65 61 74 65 20 6d 6f 72 65	es.s8...--.before.we.create.more
0c00	20 73 6f 70 68 69 73 74 69 63 61 74 65 64 20 66 75 6e 63 74 69 6f 6e 73 2c 20 6c 65 74 27 73 20	.sophisticated.functions,.let's.
0c20	73 18 00 00 00 2d 2d 20 70 6f 70 75 6c 61 74 65 20 61 6e 20 45 4d 50 20 74 61 62 6c 65 73 12 00	s....--.populate.an.EMP.tables..
0c40	00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 45 4d 50 20 28 73 0f 00 00 00 09 20 20 20 6e 61 6d	..CREATE.TABLE.EMP.(s........nam
0c60	65 09 09 74 65 78 74 2c 73 10 00 00 00 20 20 20 20 73 61 6c 61 72 79 09 69 6e 74 34 2c 73 0e 00	e..text,s........salary.int4,s..
0c80	00 00 20 20 20 20 61 67 65 09 09 69 6e 74 34 2c 73 10 00 00 00 20 20 20 20 64 65 70 74 09 09 63	......age..int4,s........dept..c
0ca0	68 61 72 31 36 73 01 00 00 00 29 73 41 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 45 4d 50	har16s....)sA...CREATE.TABLE.EMP
0cc0	20 28 6e 61 6d 65 09 09 74 65 78 74 2c 73 61 6c 61 72 79 09 09 69 6e 74 34 2c 61 67 65 09 09 69	.(name..text,salary..int4,age..i
0ce0	6e 74 34 2c 64 65 70 74 09 09 63 68 61 72 31 36 29 73 2f 00 00 00 49 4e 53 45 52 54 20 49 4e 54	nt4,dept..char16)s/...INSERT.INT
0d00	4f 20 45 4d 50 20 56 41 4c 55 45 53 20 28 27 53 61 6d 27 2c 20 31 32 30 30 2c 20 31 36 2c 20 27	O.EMP.VALUES.('Sam',.1200,.16,.'
0d20	74 6f 79 27 29 73 33 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 45 4d 50 20 56 41 4c 55 45 53	toy')s3...INSERT.INTO.EMP.VALUES
0d40	20 28 27 43 6c 61 69 72 65 27 2c 20 35 30 30 30 2c 20 33 32 2c 20 27 73 68 6f 65 27 29 73 32 00	.('Claire',.5000,.32,.'shoe')s2.
0d60	00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 45 4d 50 20 56 41 4c 55 45 53 20 28 27 41 6e 64 79 27	..INSERT.INTO.EMP.VALUES.('Andy'
0d80	2c 20 2d 31 30 30 30 2c 20 32 2c 20 27 63 61 6e 64 79 27 29 73 31 00 00 00 49 4e 53 45 52 54 20	,.-1000,.2,.'candy')s1...INSERT.
0da0	49 4e 54 4f 20 45 4d 50 20 56 41 4c 55 45 53 20 28 27 42 69 6c 6c 27 2c 20 34 32 30 30 2c 20 33	INTO.EMP.VALUES.('Bill',.4200,.3
0dc0	36 2c 20 27 73 68 6f 65 27 29 73 34 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 45 4d 50 20 56	6,.'shoe')s4...INSERT.INTO.EMP.V
0de0	41 4c 55 45 53 20 28 27 47 69 6e 67 65 72 27 2c 20 34 38 30 30 2c 20 33 30 2c 20 27 63 61 6e 64	ALUES.('Ginger',.4800,.30,.'cand
0e00	79 27 29 73 37 00 00 00 2d 2d 20 74 68 65 20 61 72 67 75 6d 65 6e 74 20 6f 66 20 61 20 66 75 6e	y')s7...--.the.argument.of.a.fun
0e20	63 74 69 6f 6e 20 63 61 6e 20 61 6c 73 6f 20 62 65 20 61 20 74 75 70 6c 65 2e 20 46 6f 72 20 73	ction.can.also.be.a.tuple..For.s
0e40	39 00 00 00 2d 2d 20 69 6e 73 74 61 6e 63 65 2c 20 64 6f 75 62 6c 65 5f 73 61 6c 61 72 79 20 74	9...--.instance,.double_salary.t
0e60	61 6b 65 73 20 61 20 74 75 70 6c 65 20 6f 66 20 74 68 65 20 45 4d 50 20 74 61 62 6c 65 73 2f 00	akes.a.tuple.of.the.EMP.tables/.
0e80	00 00 43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20 64 6f 75 62 6c 65 5f 73 61 6c 61 72 79 28	..CREATE.FUNCTION.double_salary(
0ea0	45 4d 50 29 20 52 45 54 55 52 4e 53 20 69 6e 74 34 73 35 00 00 00 20 20 20 41 53 20 27 53 45 4c	EMP).RETURNS.int4s5......AS.'SEL
0ec0	45 43 54 20 24 31 2e 73 61 6c 61 72 79 20 2a 20 32 20 41 53 20 73 61 6c 61 72 79 27 20 4c 41 4e	ECT.$1.salary.*.2.AS.salary'.LAN
0ee0	47 55 41 47 45 20 27 73 71 6c 27 73 62 00 00 00 43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20	GUAGE.'sql'sb...CREATE.FUNCTION.
0f00	64 6f 75 62 6c 65 5f 73 61 6c 61 72 79 28 45 4d 50 29 20 52 45 54 55 52 4e 53 20 69 6e 74 34 20	double_salary(EMP).RETURNS.int4.
0f20	41 53 20 27 53 45 4c 45 43 54 20 24 31 2e 73 61 6c 61 72 79 20 2a 20 32 20 41 53 20 73 61 6c 61	AS.'SELECT.$1.salary.*.2.AS.sala
0f40	72 79 27 20 4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 28 00 00 00 53 45 4c 45 43 54 20 6e 61	ry'.LANGUAGE.'sql's(...SELECT.na
0f60	6d 65 2c 20 64 6f 75 62 6c 65 5f 73 61 6c 61 72 79 28 45 4d 50 29 20 41 53 20 64 72 65 61 6d 73	me,.double_salary(EMP).AS.dreams
0f80	08 00 00 00 46 52 4f 4d 20 45 4d 50 73 16 00 00 00 57 48 45 52 45 20 45 4d 50 2e 64 65 70 74 20	....FROM.EMPs....WHERE.EMP.dept.
0fa0	3d 20 27 74 6f 79 27 73 48 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 2c 20 64 6f 75 62 6c 65 5f	=.'toy'sH...SELECT.name,.double_
0fc0	73 61 6c 61 72 79 28 45 4d 50 29 20 41 53 20 64 72 65 61 6d 20 46 52 4f 4d 20 45 4d 50 20 57 48	salary(EMP).AS.dream.FROM.EMP.WH
0fe0	45 52 45 20 45 4d 50 2e 64 65 70 74 20 3d 20 27 74 6f 79 27 73 3f 00 00 00 2d 2d 20 74 68 65 20	ERE.EMP.dept.=.'toy's?...--.the.
1000	72 65 74 75 72 6e 20 76 61 6c 75 65 20 6f 66 20 61 20 66 75 6e 63 74 69 6f 6e 20 63 61 6e 20 61	return.value.of.a.function.can.a
1020	6c 73 6f 20 62 65 20 61 20 74 75 70 6c 65 2e 20 48 6f 77 65 76 65 72 2c 73 3f 00 00 00 2d 2d 20	lso.be.a.tuple..However,s?...--.
1040	6d 61 6b 65 20 73 75 72 65 20 74 68 61 74 20 74 68 65 20 65 78 70 72 65 73 73 69 6f 6e 73 20 69	make.sure.that.the.expressions.i
1060	6e 20 74 68 65 20 74 61 72 67 65 74 20 6c 69 73 74 20 69 73 20 69 6e 20 74 68 65 20 73 24 00 00	n.the.target.list.is.in.the.s$..
1080	00 2d 2d 20 73 61 6d 65 20 6f 72 64 65 72 20 61 73 20 74 68 65 20 63 6f 6c 75 6d 6e 73 20 6f 66	.--.same.order.as.the.columns.of
10a0	20 45 4d 50 2e 73 25 00 00 00 43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20 6e 65 77 5f 65 6d	.EMP.s%...CREATE.FUNCTION.new_em
10c0	70 28 29 20 52 45 54 55 52 4e 53 20 45 4d 50 73 23 00 00 00 20 20 20 41 53 20 27 53 45 4c 45 43	p().RETURNS.EMPs#......AS.'SELEC
10e0	54 20 27 4e 6f 6e 65 27 3a 3a 74 65 78 74 20 41 53 20 6e 61 6d 65 2c 73 1d 00 00 00 20 20 20 20	T.'None'::text.AS.name,s........
1100	20 20 20 20 20 20 20 20 20 20 31 30 30 30 20 41 53 20 73 61 6c 61 72 79 2c 73 18 00 00 00 20 20	..........1000.AS.salary,s......
1120	20 20 20 20 20 20 20 20 20 20 20 20 32 35 20 41 53 20 61 67 65 2c 73 25 00 00 00 20 20 20 20 20	............25.AS.age,s%........
1140	20 20 20 20 20 20 20 20 20 27 6e 6f 6e 65 27 3a 3a 63 68 61 72 31 36 20 41 53 20 64 65 70 74 27	.........'none'::char16.AS.dept'
1160	73 11 00 00 00 20 20 20 4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 8c 00 00 00 43 52 45 41 54	s.......LANGUAGE.'sql's....CREAT
1180	45 20 46 55 4e 43 54 49 4f 4e 20 6e 65 77 5f 65 6d 70 28 29 20 52 45 54 55 52 4e 53 20 45 4d 50	E.FUNCTION.new_emp().RETURNS.EMP
11a0	20 41 53 20 27 53 45 4c 45 43 54 20 5c 27 4e 6f 6e 65 5c 27 3a 3a 74 65 78 74 20 41 53 20 6e 61	.AS.'SELECT.\'None\'::text.AS.na
11c0	6d 65 2c 20 31 30 30 30 20 41 53 20 73 61 6c 61 72 79 2c 20 32 35 20 41 53 20 61 67 65 2c 20 5c	me,.1000.AS.salary,.25.AS.age,.\
11e0	27 6e 6f 6e 65 5c 27 3a 3a 63 68 61 72 31 36 20 41 53 20 64 65 70 74 27 20 4c 41 4e 47 55 41 47	'none\'::char16.AS.dept'.LANGUAG
1200	45 20 27 73 71 6c 27 73 3e 00 00 00 2d 2d 20 79 6f 75 20 63 61 6e 20 74 68 65 6e 20 70 72 6f 6a	E.'sql's>...--.you.can.then.proj
1220	65 63 74 20 61 20 63 6f 6c 75 6d 6e 20 6f 75 74 20 6f 66 20 72 65 73 75 6c 74 69 6e 67 20 74 68	ect.a.column.out.of.resulting.th
1240	65 20 74 75 70 6c 65 20 62 79 73 39 00 00 00 2d 2d 20 75 73 69 6e 67 20 74 68 65 20 22 66 75 6e	e.tuple.bys9...--.using.the."fun
1260	63 74 69 6f 6e 20 6e 6f 74 61 74 69 6f 6e 22 20 66 6f 72 20 70 72 6f 6a 65 63 74 69 6f 6e 20 63	ction.notation".for.projection.c
1280	6f 6c 75 6d 6e 73 2e 20 73 3d 00 00 00 2d 2d 20 28 69 65 2e 20 62 61 72 28 66 6f 6f 29 20 69 73	olumns..s=...--.(ie..bar(foo).is
12a0	20 65 71 75 69 76 61 6c 65 6e 74 20 74 6f 20 66 6f 6f 2e 62 61 72 29 20 4e 6f 74 65 20 74 68 61	.equivalent.to.foo.bar).Note.tha
12c0	74 20 77 65 20 64 6f 6e 27 74 73 29 00 00 00 2d 2d 20 73 75 70 70 6f 72 74 20 6e 65 77 5f 65 6d	t.we.don'ts)...--.support.new_em
12e0	70 28 29 2e 6e 61 6d 65 20 61 74 20 74 68 69 73 20 6d 6f 6d 65 6e 74 2e 73 20 00 00 00 53 45 4c	p().name.at.this.moment.s....SEL
1300	45 43 54 20 6e 61 6d 65 28 6e 65 77 5f 65 6d 70 28 29 29 20 41 53 20 6e 6f 62 6f 64 79 73 32 00	ECT.name(new_emp()).AS.nobodys2.
1320	00 00 2d 2d 20 6c 65 74 27 73 20 74 72 79 20 6f 6e 65 20 6d 6f 72 65 20 66 75 6e 63 74 69 6f 6e	..--.let's.try.one.more.function
1340	20 74 68 61 74 20 72 65 74 75 72 6e 73 20 74 75 70 6c 65 73 73 2c 00 00 00 43 52 45 41 54 45 20	.that.returns.tupless,...CREATE.
1360	46 55 4e 43 54 49 4f 4e 20 68 69 67 68 5f 70 61 79 28 29 20 52 45 54 55 52 4e 53 20 73 65 74 6f	FUNCTION.high_pay().RETURNS.seto
1380	66 20 45 4d 50 73 2d 00 00 00 20 20 20 41 53 20 27 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 45	f.EMPs-......AS.'SELECT.*.FROM.E
13a0	4d 50 20 77 68 65 72 65 20 73 61 6c 61 72 79 20 3e 20 31 35 30 30 27 73 66 00 00 00 43 52 45 41	MP.where.salary.>.1500'sf...CREA
13c0	54 45 20 46 55 4e 43 54 49 4f 4e 20 68 69 67 68 5f 70 61 79 28 29 20 52 45 54 55 52 4e 53 20 73	TE.FUNCTION.high_pay().RETURNS.s
13e0	65 74 6f 66 20 45 4d 50 20 41 53 20 27 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 45 4d 50 20 77	etof.EMP.AS.'SELECT.*.FROM.EMP.w
1400	68 65 72 65 20 73 61 6c 61 72 79 20 3e 20 31 35 30 30 27 20 4c 41 4e 47 55 41 47 45 20 27 73 71	here.salary.>.1500'.LANGUAGE.'sq
1420	6c 27 73 23 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 28 68 69 67 68 5f 70 61 79 28 29 29 20 41	l's#...SELECT.name(high_pay()).A
1440	53 20 6f 76 65 72 70 61 69 64 28 07 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75	S.overpaid(....s....pgcnxs....qu
1460	65 72 79 73 08 00 00 00 77 61 69 74 5f 6b 65 79 73 01 00 00 00 71 73 07 00 00 00 64 69 73 70 6c	erys....wait_keys....qs....displ
1480	61 79 73 0a 00 00 00 6c 69 73 74 66 69 65 6c 64 73 73 09 00 00 00 67 65 74 72 65 73 75 6c 74 28	ays....listfieldss....getresult(
14a0	02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 01 00 00 00 71 73 07 00 00 00 66 75 6e 63 2e 70 79	....s....pgcnxs....qs....func.py
14c0	73 09 00 00 00 63 6f 6d 70 5f 66 75 6e 63 3c 00 73 92 00 00 00 03 01 08 01 08 01 08 01 08 01 08	s....comp_func<.s...............
14e0	01 04 01 08 01 08 01 04 01 08 01 08 01 08 01 08 01 08 01 08 01 10 05 04 01 08 01 08 01 08 01 08	................................
1500	01 08 01 10 01 10 01 10 01 10 01 10 01 0a 01 04 01 08 01 08 01 04 01 08 01 08 01 10 02 04 01 08	................................
1520	01 08 01 08 01 12 02 1c 01 04 01 08 01 08 01 08 01 04 01 08 01 08 01 08 01 08 01 08 01 08 01 10	................................
1540	06 0a 01 04 01 08 01 08 01 08 01 08 01 04 01 08 01 12 01 1c 01 04 01 08 01 08 01 08 01 08 01 10	................................
1560	03 04 01 08 01 12 01 63 01 00 02 00 03 00 03 00 73 2d 01 00 00 7f 95 00 7f 96 00 64 01 00 47 48	.......c........s-.........d..GH
1580	7f 97 00 64 02 00 47 48 7f 98 00 64 03 00 47 48 7f 99 00 64 04 00 47 48 7f 9a 00 64 01 00 47 48	...d..GH...d..GH...d..GH...d..GH
15a0	7f 9b 00 48 7f 9c 00 64 05 00 47 48 7f 9d 00 64 06 00 47 48 7f 9e 00 64 07 00 47 48 7f 9f 00 48	...H...d..GH...d..GH...d..GH...H
15c0	7f a0 00 64 08 00 47 48 7f a1 00 7c 00 00 69 01 00 64 08 00 83 01 00 7d 01 00 7f a2 00 74 03 00	...d..GH...|..i..d.....}.....t..
15e0	7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f a3 00 48 7f a4 00 64 09 00	|..i.....|..i............H...d..
1600	47 48 7f a5 00 64 0a 00 47 48 7f a6 00 64 0b 00 47 48 7f a7 00 64 0c 00 47 48 7f a8 00 7c 00 00	GH...d..GH...d..GH...d..GH...|..
1620	69 01 00 64 0d 00 83 01 00 01 7f a9 00 48 7f aa 00 64 0e 00 47 48 7f ab 00 7c 00 00 69 01 00 64	i..d.........H...d..GH...|..i..d
1640	0e 00 83 01 00 7d 01 00 7f ac 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00	.....}.....t..|..i.....|..i.....
1660	83 02 00 01 7f ad 00 48 7f ae 00 64 08 00 47 48 7f af 00 7c 00 00 69 01 00 64 08 00 83 01 00 7d	.......H...d..GH...|..i..d.....}
1680	01 00 7f b0 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 64 00	.....t..|..i.....|..i.........d.
16a0	00 53 28 0f 00 00 00 4e 73 1d 00 00 00 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d	.S(....Ns....-------------------
16c0	2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 73 36 00 00 00 2d 2d 20 43 72 65 61 74 69 6e 67 20 53 51 4c 20 46	----------s6...--.Creating.SQL.F
16e0	75 6e 63 74 69 6f 6e 73 20 77 69 74 68 20 6d 75 6c 74 69 70 6c 65 20 53 51 4c 20 73 74 61 74 65	unctions.with.multiple.SQL.state
1700	6d 65 6e 74 73 73 39 00 00 00 2d 2d 09 79 6f 75 20 63 61 6e 20 61 6c 73 6f 20 63 72 65 61 74 65	mentss9...--.you.can.also.create
1720	20 66 75 6e 63 74 69 6f 6e 73 20 74 68 61 74 20 64 6f 20 6d 6f 72 65 20 74 68 61 6e 20 6a 75 73	.functions.that.do.more.than.jus
1740	74 20 61 73 0a 00 00 00 2d 2d 09 53 45 4c 45 43 54 2e 73 3e 00 00 00 2d 2d 20 79 6f 75 20 6d 61	t.as....--.SELECT.s>...--.you.ma
1760	79 20 68 61 76 65 20 6e 6f 74 69 63 65 64 20 74 68 61 74 20 41 6e 64 79 20 68 61 73 20 61 20 6e	y.have.noticed.that.Andy.has.a.n
1780	65 67 61 74 69 76 65 20 73 61 6c 61 72 79 2e 20 57 65 27 6c 6c 73 3a 00 00 00 2d 2d 20 63 72 65	egative.salary..We'lls:...--.cre
17a0	61 74 65 20 61 20 66 75 6e 63 74 69 6f 6e 20 74 68 61 74 20 72 65 6d 6f 76 65 73 20 65 6d 70 6c	ate.a.function.that.removes.empl
17c0	6f 79 65 65 73 20 77 69 74 68 20 6e 65 67 61 74 69 76 65 20 73 0c 00 00 00 2d 2d 20 73 61 6c 61	oyees.with.negative.s....--.sala
17e0	72 69 65 73 2e 73 11 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 45 4d 50 73 29 00 00 00	ries.s....SELECT.*.FROM.EMPs)...
1800	43 52 45 41 54 45 20 46 55 4e 43 54 49 4f 4e 20 63 6c 65 61 6e 5f 45 4d 50 20 28 29 20 52 45 54	CREATE.FUNCTION.clean_EMP.().RET
1820	55 52 4e 53 20 69 6e 74 34 73 2c 00 00 00 20 20 20 41 53 20 27 44 45 4c 45 54 45 20 46 52 4f 4d	URNS.int4s,......AS.'DELETE.FROM
1840	20 45 4d 50 20 57 48 45 52 45 20 45 4d 50 2e 73 61 6c 61 72 79 20 3c 3d 20 30 73 1f 00 00 00 20	.EMP.WHERE.EMP.salary.<=.0s.....
1860	20 20 20 20 20 20 53 45 4c 45 43 54 20 31 20 41 53 20 69 67 6e 6f 72 65 5f 74 68 69 73 27 73 11	......SELECT.1.AS.ignore_this's.
1880	00 00 00 20 20 20 4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 7c 00 00 00 43 52 45 41 54 45 20	......LANGUAGE.'sql's|...CREATE.
18a0	46 55 4e 43 54 49 4f 4e 20 63 6c 65 61 6e 5f 45 4d 50 20 28 29 20 52 45 54 55 52 4e 53 20 69 6e	FUNCTION.clean_EMP.().RETURNS.in
18c0	74 34 20 41 53 20 27 44 45 4c 45 54 45 20 46 52 4f 4d 20 45 4d 50 20 57 48 45 52 45 20 45 4d 50	t4.AS.'DELETE.FROM.EMP.WHERE.EMP
18e0	2e 73 61 6c 61 72 79 20 3c 3d 20 30 3b 20 53 45 4c 45 43 54 20 31 20 41 53 20 69 67 6e 6f 72 65	.salary.<=.0;.SELECT.1.AS.ignore
1900	5f 74 68 69 73 27 20 4c 41 4e 47 55 41 47 45 20 27 73 71 6c 27 73 12 00 00 00 53 45 4c 45 43 54	_this'.LANGUAGE.'sql's....SELECT
1920	20 63 6c 65 61 6e 5f 45 4d 50 28 29 28 06 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00	.clean_EMP()(....s....pgcnxs....
1940	71 75 65 72 79 73 01 00 00 00 71 73 07 00 00 00 64 69 73 70 6c 61 79 73 0a 00 00 00 6c 69 73 74	querys....qs....displays....list
1960	66 69 65 6c 64 73 73 09 00 00 00 67 65 74 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67	fieldss....getresult(....s....pg
1980	63 6e 78 73 01 00 00 00 71 73 07 00 00 00 66 75 6e 63 2e 70 79 73 09 00 00 00 6d 75 6c 74 5f 66	cnxs....qs....func.pys....mult_f
19a0	75 6e 63 95 00 73 36 00 00 00 03 01 08 01 08 01 08 01 08 01 08 01 04 01 08 01 08 01 08 01 04 01	unc..s6.........................
19c0	08 01 12 01 1c 01 04 01 08 01 08 01 08 01 08 01 10 01 04 01 08 01 12 01 1c 01 04 01 08 01 12 01	................................
19e0	63 01 00 01 00 02 00 03 00 73 a7 00 00 00 7f b3 00 7f b4 00 64 01 00 47 48 7f b5 00 48 7f b6 00	c........s..........d..GH...H...
1a00	64 02 00 47 48 7f b7 00 64 03 00 47 48 7f b8 00 64 04 00 47 48 7f b9 00 64 05 00 47 48 7f ba 00	d..GH...d..GH...d..GH...d..GH...
1a20	64 06 00 47 48 7f bb 00 48 7f bc 00 64 07 00 47 48 7f bd 00 7c 00 00 69 01 00 64 02 00 83 01 00	d..GH...H...d..GH...|..i..d.....
1a40	01 7f be 00 7c 00 00 69 01 00 64 03 00 83 01 00 01 7f bf 00 7c 00 00 69 01 00 64 04 00 83 01 00	....|..i..d.........|..i..d.....
1a60	01 7f c0 00 7c 00 00 69 01 00 64 05 00 83 01 00 01 7f c1 00 7c 00 00 69 01 00 64 06 00 83 01 00	....|..i..d.........|..i..d.....
1a80	01 7f c2 00 7c 00 00 69 01 00 64 07 00 83 01 00 01 64 00 00 53 28 08 00 00 00 4e 73 32 00 00 00	....|..i..d......d..S(....Ns2...
1aa0	2d 2d 20 72 65 6d 6f 76 65 20 66 75 6e 63 74 69 6f 6e 73 20 74 68 61 74 20 77 65 72 65 20 63 72	--.remove.functions.that.were.cr
1ac0	65 61 74 65 64 20 69 6e 20 74 68 69 73 20 66 69 6c 65 73 19 00 00 00 44 52 4f 50 20 46 55 4e 43	eated.in.this.files....DROP.FUNC
1ae0	54 49 4f 4e 20 63 6c 65 61 6e 5f 45 4d 50 28 29 73 18 00 00 00 44 52 4f 50 20 46 55 4e 43 54 49	TION.clean_EMP()s....DROP.FUNCTI
1b00	4f 4e 20 68 69 67 68 5f 70 61 79 28 29 73 17 00 00 00 44 52 4f 50 20 46 55 4e 43 54 49 4f 4e 20	ON.high_pay()s....DROP.FUNCTION.
1b20	6e 65 77 5f 65 6d 70 28 29 73 20 00 00 00 44 52 4f 50 20 46 55 4e 43 54 49 4f 4e 20 61 64 64 5f	new_emp()s....DROP.FUNCTION.add_
1b40	65 6d 28 69 6e 74 34 2c 20 69 6e 74 34 29 73 13 00 00 00 44 52 4f 50 20 46 55 4e 43 54 49 4f 4e	em(int4,.int4)s....DROP.FUNCTION
1b60	20 6f 6e 65 28 29 73 0e 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 45 4d 50 28 02 00 00 00 73 05	.one()s....DROP.TABLE.EMP(....s.
1b80	00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 28 01 00 00 00 73 05 00 00 00 70 67 63 6e	...pgcnxs....query(....s....pgcn
1ba0	78 73 07 00 00 00 66 75 6e 63 2e 70 79 73 0c 00 00 00 64 65 6d 6f 5f 63 6c 65 61 6e 75 70 b3 00	xs....func.pys....demo_cleanup..
1bc0	73 1e 00 00 00 03 01 08 01 04 01 08 01 08 01 08 01 08 01 08 01 04 01 08 01 10 01 10 01 10 01 10	s...............................
1be0	01 10 01 63 01 00 01 00 02 00 03 00 73 3b 00 00 00 7f c5 00 7f c6 00 74 00 00 7c 00 00 83 01 00	...c........s;.........t..|.....
1c00	01 7f c7 00 74 02 00 7c 00 00 83 01 00 01 7f c8 00 74 03 00 7c 00 00 83 01 00 01 7f c9 00 74 04	....t..|.........t..|.........t.
1c20	00 7c 00 00 83 01 00 01 64 00 00 53 28 01 00 00 00 4e 28 05 00 00 00 73 09 00 00 00 62 61 73 65	.|......d..S(....N(....s....base
1c40	5f 66 75 6e 63 73 05 00 00 00 70 67 63 6e 78 73 09 00 00 00 63 6f 6d 70 5f 66 75 6e 63 73 09 00	_funcs....pgcnxs....comp_funcs..
1c60	00 00 6d 75 6c 74 5f 66 75 6e 63 73 0c 00 00 00 64 65 6d 6f 5f 63 6c 65 61 6e 75 70 28 01 00 00	..mult_funcs....demo_cleanup(...
1c80	00 73 05 00 00 00 70 67 63 6e 78 73 07 00 00 00 66 75 6e 63 2e 70 79 73 04 00 00 00 64 65 6d 6f	.s....pgcnxs....func.pys....demo
1ca0	c5 00 73 08 00 00 00 03 01 0d 01 0d 01 0d 01 4e 28 08 00 00 00 73 07 00 00 00 70 67 74 6f 6f 6c	..s............N(....s....pgtool
1cc0	73 73 01 00 00 00 2a 73 05 00 00 00 70 67 65 78 74 73 09 00 00 00 62 61 73 65 5f 66 75 6e 63 73	ss....*s....pgexts....base_funcs
1ce0	09 00 00 00 63 6f 6d 70 5f 66 75 6e 63 73 09 00 00 00 6d 75 6c 74 5f 66 75 6e 63 73 0c 00 00 00	....comp_funcs....mult_funcs....
1d00	64 65 6d 6f 5f 63 6c 65 61 6e 75 70 73 04 00 00 00 64 65 6d 6f 28 00 00 00 00 73 07 00 00 00 66	demo_cleanups....demo(....s....f
1d20	75 6e 63 2e 70 79 73 01 00 00 00 3f 05 00 73 1e 00 00 00 0b 01 08 01 04 01 08 01 04 01 08 01 08	unc.pys....?..s.................
1d40	01 08 01 08 02 0a 01 0a 03 0c 29 0c 59 0c 1e 0c 12	..........).Y....