77 *
88 * Copyright (c) 1994, Regents of the University of California
99 *
10- * $Id: pg_type.h,v 1.67 1999/10/1811:36:45 momjian Exp $
10+ * $Id: pg_type.h,v 1.68 1999/10/1813:44:24 momjian Exp $
1111 *
1212 * NOTES
1313 * the genbki.sh script reads this file and generates .bki
@@ -151,7 +151,7 @@ typedef FormData_pg_type *Form_pg_type;
151151
152152/* OIDS 1 - 99 */
153153DATA (insert OID = 16 (bool PGUID 1 1 t b t \054 0 0 boolin boolout boolin boolout c _null_ ));
154- DESCR ("boolean 'true'/'false'" );
154+ DESCR ("boolean, 'true'/'false'" );
155155#define BOOLOID 16
156156
157157DATA (insert OID = 17 (bytea PGUID - 1 - 1 f b t \054 0 18 byteain byteaout byteain byteaout i _null_ ));
@@ -167,15 +167,15 @@ DESCR("31-character type for storing system identifiers");
167167#define NAMEOID 19
168168
169169DATA (insert OID = 20 (int8 PGUID 8 20 f b t \054 0 0 int8in int8out int8in int8out d _null_ ));
170- DESCR ("~18digits, eight-byte integer, " );
170+ DESCR ("~18digit integer,8-bytes " );
171171#define INT8OID 20
172172
173173DATA (insert OID = 21 (int2 PGUID 2 5 t b t \054 0 0 int2in int2out int2in int2out s _null_ ));
174- DESCR ("two-byte integer, -32k to 32k " );
174+ DESCR ("-32 thousand to 32 thousand, 2-byte storage, " );
175175#define INT2OID 21
176176
177177DATA (insert OID = 22 (int28 PGUID 16 50 f b t \054 0 21 int28in int28out int28in int28out i _null_ ));
178- DESCR ("82-byte integers, used internally" );
178+ DESCR ("8int2 integers, used internally" );
179179/*
180180 * XXX -- the implementation of int28's in postgres is a hack, and will
181181 * go away someday.until that happens, there is a case (in the
@@ -194,15 +194,15 @@ DESCR("registered procedure");
194194#define REGPROCOID 24
195195
196196DATA (insert OID = 25 (text PGUID - 1 - 1 f b t \054 0 18 textin textout textin textout i _null_ ));
197- DESCR ("native variable-length string" );
197+ DESCR ("variable-length string, no limit specified " );
198198#define TEXTOID 25
199199
200200DATA (insert OID = 26 (oid PGUID 4 10 t b t \054 0 0 int4in int4out int4in int4out i _null_ ));
201- DESCR ("object identifier type " );
201+ DESCR ("object identifier(oid), maximum 4 billion " );
202202#define OIDOID 26
203203
204204DATA (insert OID = 27 (tid PGUID 6 19 f b t \054 0 0 tidin tidout tidin tidout i _null_ ));
205- DESCR ("tuple identifier type , physical location of tuple" );
205+ DESCR ("(Block, offset) , physical location of tuple" );
206206#define TIDOID 27
207207
208208DATA (insert OID = 28 (xid PGUID 4 12 t b t \054 0 0 xidin xidout xidin xidout i _null_ ));
@@ -214,7 +214,7 @@ DESCR("command identifier type, sequence in transaction id");
214214#define CIDOID 29
215215
216216DATA (insert OID = 30 (oid8 PGUID 32 89 f b t \054 0 26 oid8in oid8out oid8in oid8out i _null_ ));
217- DESCR ("array of 8oid , used in system tables" );
217+ DESCR ("array of 8oids , used in system tables" );
218218DATA (insert OID = 32 (SET PGUID - 1 - 1 f b t \054 0 0 textin textout textin textout i _null_ ));
219219DESCR ("set of tuples" );
220220
@@ -285,7 +285,7 @@ DATA(insert OID = 703 ( reltime PGUID 4 20 t b t \054 0 0 reltimein relti
285285DESCR ("relative, limited-range time interval (Unix delta time)" );
286286#define RELTIMEOID 703
287287DATA (insert OID = 704 (tinterval PGUID 12 47 f b t \054 0 0 tintervalin tintervalout tintervalin tintervalout i _null_ ));
288- DESCR ("time interval ' (abstime,abstime)' " );
288+ DESCR ("(abstime,abstime), time interval " );
289289DATA (insert OID = 705 (unknown PGUID - 1 - 1 f b t \054 0 18 textin textout textin textout i _null_ ));
290290DESCR ("" );
291291#define UNKNOWNOID 705
@@ -295,18 +295,18 @@ DESCR("geometric circle '(center,radius)'");
295295#define CIRCLEOID 718
296296DATA (insert OID = 719 (_circle PGUID - 1 - 1 f b t \054 0 718 array_in array_out array_in array_out d _null_ ));
297297DATA (insert OID = 790 (money PGUID 4 24 f b t \054 0 0 cash_in cash_out cash_in cash_out i _null_ ));
298- DESCR ("money ' $d,ddd.cc' " );
298+ DESCR ("$d,ddd.cc, money " );
299299#define CASHOID 790
300300DATA (insert OID = 791 (_money PGUID - 1 - 1 f b t \054 0 790 array_in array_out array_in array_out i _null_ ));
301301
302302/* OIDS 800 - 899 */
303303DATA (insert OID = 829 (macaddr PGUID 6 - 1 f b t \054 0 0 macaddr_in macaddr_out macaddr_in macaddr_out i _null_ ));
304- DESCR ("MAC address" );
304+ DESCR ("XX:XX:XX:XX:XX, MAC address" );
305305DATA (insert OID = 869 (inet PGUID - 1 - 1 f b t \054 0 0 inet_in inet_out inet_in inet_out i _null_ ));
306- DESCR ("Host address" );
306+ DESCR ("IP address/netmask, host address, netmask optional " );
307307#define INETOID 869
308308DATA (insert OID = 650 (cidr PGUID - 1 - 1 f b t \054 0 0 cidr_in cidr_out cidr_in cidr_out i _null_ ));
309- DESCR ("Network address" );
309+ DESCR ("network IP address/netmask, network address" );
310310#define CIDROID 650
311311
312312/* OIDS 900 - 999 */
@@ -352,17 +352,17 @@ DATA(insert OID = 1040 ( _macaddr PGUID -1 -1 f b t \054 0 829 array_in array
352352DATA (insert OID = 1041 (_inet PGUID - 1 - 1 f b t \054 0 869 array_in array_out array_in array_out i _null_ ));
353353DATA (insert OID = 651 (_cidr PGUID - 1 - 1 f b t \054 0 650 array_in array_out array_in array_out i _null_ ));
354354DATA (insert OID = 1042 (bpchar PGUID - 1 - 1 f b t \054 0 18 bpcharin bpcharout bpcharin bpcharout i _null_ ));
355- DESCR ("blank-paddedcharacters, length specified when created -- char() " );
355+ DESCR ("char(length), blank-paddedstring, fixed storage length " );
356356#define BPCHAROID 1042
357357DATA (insert OID = 1043 (varchar PGUID - 1 - 1 f b t \054 0 18 varcharin varcharout varcharin varcharout i _null_ ));
358- DESCR ("non-blank-padded-length string,length specified when created -- varchar() " );
358+ DESCR ("varchar(length), non-blank-padded string,variable storage length " );
359359#define VARCHAROID 1043
360360
361361DATA (insert OID = 1082 (date PGUID 4 10 t b t \054 0 0 date_in date_out date_in date_out i _null_ ));
362- DESCR ("ANSI SQL date ' yyyy-mm-dd' " );
362+ DESCR ("yyyy-mm-dd, ANSI SQL date " );
363363#define DATEOID 1082
364364DATA (insert OID = 1083 (time PGUID 8 16 f b t \054 0 0 time_in time_out time_in time_out d _null_ ));
365- DESCR ("ANSI SQL time ' hh:mm:ss' " );
365+ DESCR ("hh:mm:ss, ANSI SQL time " );
366366#define TIMEOID 1083
367367
368368/* OIDS 1100 - 1199 */
@@ -373,18 +373,18 @@ DESCR("date and time 'yyyy-mm-dd hh:mm:ss'");
373373#define DATETIMEOID 1184
374374DATA (insert OID = 1185 (_datetime PGUID - 1 - 1 f b t \054 0 1184 array_in array_out array_in array_out d _null_ ));
375375DATA (insert OID = 1186 (timespan PGUID 12 47 f b t \054 0 0 timespan_in timespan_out timespan_in timespan_out d _null_ ));
376- DESCR ("time interval ' @ <number> <units>' " );
376+ DESCR ("@ <number> <units>, time interval " );
377377#define TIMESPANOID 1186
378378DATA (insert OID = 1187 (_timespan PGUID - 1 - 1 f b t \054 0 1186 array_in array_out array_in array_out d _null_ ));
379379
380380/* OIDS 1200 - 1299 */
381381DATA (insert OID = 1296 (timestamp PGUID 4 19 t b t \054 0 0 timestamp_in timestamp_out timestamp_in timestamp_out i _null_ ));
382- DESCR ("limited-range ISO-format date and time" );
382+ DESCR ("date time timezone, limited-range ISO-formated date and time" );
383383#define TIMESTAMPOID 1296
384384
385385/* OIDS 1700 - 1799 */
386386DATA (insert OID = 1700 (numeric PGUID - 1 - 1 f b t \054 0 0 numeric_in numeric_out numeric_in numeric_out i _null_ ));
387- DESCR ("arbitrary precision exact numeric data type " );
387+ DESCR ("numeric( precision, decimal), arbitrary precision number " );
388388#define NUMERICOID 1700
389389
390390