Add cash_words_out and fix \df width.

bmomjian · bmomjian · commit d57753efd45c · 1998-01-25T20:23:40.000Z
diff --git a/src/bin/psql/psql.c b/src/bin/psql/psql.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.129 1998/01/23 19:22:24 scrappy Exp $
+ *	  $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.130 1998/01/25 20:23:36 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -1770,7 +1770,7 @@ HandleSlashCmds(PsqlSettings *pset,
 				SendQuery(&success, pset,"\
 					SELECT	t.typname as return_type, \
 							p.proname as function, \
-							oid8types(p.proargtypes) as arguments, \
+							substr(oid8types(p.proargtypes),1,20) as arguments, \
 							substr(obj_description(p.oid),1,23) \
 					FROM 	pg_proc p, pg_type t \
 					WHERE 	p.prorettype = t.oid and \
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h
@@ -6,7 +6,7 @@
  *
  * Copyright (c) 1994, Regents of the University of California
  *
- * $Id: pg_proc.h,v 1.43 1998/01/24 22:48:41 momjian Exp $
+ * $Id: pg_proc.h,v 1.44 1998/01/25 20:23:40 momjian Exp $
  *
  * NOTES
  *	  The script catalog/genbki.sh reads this file and generates .bki
@@ -1178,6 +1178,8 @@ DATA(insert OID =  886 (  cash_in		   PGUID 11 f t f 1 f 790 "0" 100 0 0 100  fo
 DESCR("(internal)");
 DATA(insert OID =  887 (  cash_out		   PGUID 11 f t f 1 f  23 "0" 100 0 0 100  foo bar ));
 DESCR("(internal)");
+DATA(insert OID =  1273 (  cash_words_out  PGUID 11 f t f 1 f  23 "0" 100 0 0 100  foo bar ));
+DESCR("output amount as words");
 DATA(insert OID =  888 (  cash_eq		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
 DESCR("equals");
 DATA(insert OID =  889 (  cash_ne		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.129 1998/01/23 19:22:24 scrappy Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.130 1998/01/25 20:23:36 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -1770,7 +1770,7 @@ HandleSlashCmds(PsqlSettings *pset,`
`1770`	`1770`	`SendQuery(&success, pset,"\`
`1771`	`1771`	`SELECT t.typname as return_type, \`
`1772`	`1772`	`p.proname as function, \`
`1773`		`- oid8types(p.proargtypes) as arguments, \`
	`1773`	`+ substr(oid8types(p.proargtypes),1,20) as arguments, \`
`1774`	`1774`	`substr(obj_description(p.oid),1,23) \`
`1775`	`1775`	`FROM pg_proc p, pg_type t \`
`1776`	`1776`	`WHERE p.prorettype = t.oid and \`
Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`*`
`7`	`7`	`* Copyright (c) 1994, Regents of the University of California`
`8`	`8`	`*`
`9`		`- * $Id: pg_proc.h,v 1.43 1998/01/24 22:48:41 momjian Exp $`
	`9`	`+ * $Id: pg_proc.h,v 1.44 1998/01/25 20:23:40 momjian Exp $`
`10`	`10`	`*`
`11`	`11`	`* NOTES`
`12`	`12`	`* The script catalog/genbki.sh reads this file and generates .bki`
`@@ -1178,6 +1178,8 @@ DATA(insert OID = 886 ( cash_in PGUID 11 f t f 1 f 790 "0" 100 0 0 100 fo`
`1178`	`1178`	`DESCR("(internal)");`
`1179`	`1179`	`DATA(insert OID = 887 ( cash_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 foo bar ));`
`1180`	`1180`	`DESCR("(internal)");`
	`1181`	`+DATA(insert OID = 1273 ( cash_words_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 foo bar ));`
	`1182`	`+DESCR("output amount as words");`
`1181`	`1183`	`DATA(insert OID = 888 ( cash_eq PGUID 11 f t f 2 f 16 "790 790" 100 0 0 100 foo bar ));`
`1182`	`1184`	`DESCR("equals");`
`1183`	`1185`	`DATA(insert OID = 889 ( cash_ne PGUID 11 f t f 2 f 16 "790 790" 100 0 0 100 foo bar ));`