diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-02-13 04:19:54 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-02-13 04:19:54 +0000 |
| commit | 02e85e7e5fc753b40a75d5f20a2b65e8cbaf0ae8 (patch) | |
| tree | 4ff02c5e69264cbf300903499da51aec996faee2 /src | |
| parent | 7a724a02312acf7bf6df2bff93b80a79b2ad208d (diff) | |
| download | postgresql-02e85e7e5fc753b40a75d5f20a2b65e8cbaf0ae8.tar.gz postgresql-02e85e7e5fc753b40a75d5f20a2b65e8cbaf0ae8.zip | |
Add routines to convert between int8 and text/varchar types.
Fix output type for int8out, but I don't think it matters.
Diffstat (limited to 'src')
| -rw-r--r-- | src/include/catalog/pg_proc.h | 22 |
1 files changed, 20 insertions, 2 deletions
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index f1bfdf15cba..0a003577d02 100644 --- 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.87 1998/12/30 19:56:32 wieck Exp $ + * $Id: pg_proc.h,v 1.88 1999/02/13 04:19:54 thomas Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -842,7 +842,7 @@ DESCR("smaller of two"); DATA(insert OID = 460 ( int8in PGUID 11 f t f 1 f 20 "0" 100 0 0 100 foo bar )); DESCR("(internal)"); -DATA(insert OID = 461 ( int8out PGUID 11 f t f 1 f 19 "0" 100 0 0 100 foo bar )); +DATA(insert OID = 461 ( int8out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 foo bar )); DESCR("(internal)"); DATA(insert OID = 462 ( int8um PGUID 11 f t f 1 f 20 "20" 100 0 0 100 foo bar )); DESCR("unary minus"); @@ -1546,6 +1546,11 @@ DESCR("multiply"); DATA(insert OID = 1281 ( int48div PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100 foo bar )); DESCR("divide"); +DATA(insert OID = 1288 ( int8_text PGUID 11 f t f 1 f 25 "20" 100 0 0 100 foo bar )); +DESCR("convert int8 to text"); +DATA(insert OID = 1289 ( text_int8 PGUID 11 f t f 1 f 20 "25" 100 0 0 100 foo bar )); +DESCR("convert text to int8"); + DATA(insert OID = 1297 ( timestamp_in PGUID 11 f t f 1 f 1296 "0" 100 0 0 100 foo bar )); DESCR("(internal)"); DATA(insert OID = 1298 ( timestamp_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 foo bar )); @@ -2027,6 +2032,19 @@ DESCR("convert float8 to text"); DATA(insert OID = 1607 ( text PGUID 14 f t f 1 f 25 "700" 100 0 0 100 "select float4_text($1)" - )); DESCR("convert float4 to text"); +DATA(insert OID = 1619 ( varchar PGUID 14 f t f 1 f 1043 "23" 100 0 0 100 "select int4_text($1)" - )); +DESCR("convert int4 to varchar"); +DATA(insert OID = 1620 ( int4 PGUID 14 f t f 1 f 23 "1043" 100 0 0 100 "select text_int4($1)" - )); +DESCR("convert varchar to int4"); +DATA(insert OID = 1621 ( text PGUID 14 f t f 1 f 25 "20" 100 0 0 100 "select int8_text($1)" - )); +DESCR("convert int8 to text"); +DATA(insert OID = 1622 ( int8 PGUID 14 f t f 1 f 20 "25" 100 0 0 100 "select text_int8($1)" - )); +DESCR("convert text to int8"); +DATA(insert OID = 1623 ( varchar PGUID 14 f t f 1 f 1043 "20" 100 0 0 100 "select int8_text($1)" - )); +DESCR("convert int8 to varchar"); +DATA(insert OID = 1624 ( int8 PGUID 14 f t f 1 f 20 "1043" 100 0 0 100 "select text_int8($1)" - )); +DESCR("convert varchar to int8"); + /* Oracle Compatibility Related Functions - By Edmund Mergl <E.Mergl@bawue.de> */ DATA(insert OID = 868 ( strpos PGUID 14 f t f 2 f 23 "25 25" 100 0 0 100 "select textpos($1, $2)" - )); DESCR("find position of substring"); |