Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit02e85e7

Browse files
author
Thomas G. Lockhart
committed
Add routines to convert between int8 and text/varchar types.
Fix output type for int8out, but I don't think it matters.
1 parent7a724a0 commit02e85e7

File tree

1 file changed

+20
-2
lines changed

1 file changed

+20
-2
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 20 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
*
77
* Copyright (c) 1994, Regents of the University of California
88
*
9-
* $Id: pg_proc.h,v 1.87 1998/12/3019:56:32 wieck Exp $
9+
* $Id: pg_proc.h,v 1.88 1999/02/13 04:19:54 thomas Exp $
1010
*
1111
* NOTES
1212
* The script catalog/genbki.sh reads this file and generates .bki
@@ -842,7 +842,7 @@ DESCR("smaller of two");
842842

843843
DATA(insertOID=460 (int8inPGUID11ftf1f20"0"10000100foobar ));
844844
DESCR("(internal)");
845-
DATA(insertOID=461 (int8outPGUID11ftf1f19"0"10000100foobar ));
845+
DATA(insertOID=461 (int8outPGUID11ftf1f23"0"10000100foobar ));
846846
DESCR("(internal)");
847847
DATA(insertOID=462 (int8umPGUID11ftf1f20"20"10000100foobar ));
848848
DESCR("unary minus");
@@ -1546,6 +1546,11 @@ DESCR("multiply");
15461546
DATA(insertOID=1281 (int48divPGUID11ftf2f20"23 20"10000100foobar ));
15471547
DESCR("divide");
15481548

1549+
DATA(insertOID=1288 (int8_textPGUID11ftf1f25"20"10000100foobar ));
1550+
DESCR("convert int8 to text");
1551+
DATA(insertOID=1289 (text_int8PGUID11ftf1f20"25"10000100foobar ));
1552+
DESCR("convert text to int8");
1553+
15491554
DATA(insertOID=1297 (timestamp_inPGUID11ftf1f1296"0"10000100foobar ));
15501555
DESCR("(internal)");
15511556
DATA(insertOID=1298 (timestamp_outPGUID11ftf1f23"0"10000100foobar ));
@@ -2027,6 +2032,19 @@ DESCR("convert float8 to text");
20272032
DATA(insertOID=1607 (textPGUID14ftf1f25"700"10000100"select float4_text($1)"- ));
20282033
DESCR("convert float4 to text");
20292034

2035+
DATA(insertOID=1619 (varcharPGUID14ftf1f1043"23"10000100"select int4_text($1)"- ));
2036+
DESCR("convert int4 to varchar");
2037+
DATA(insertOID=1620 (int4PGUID14ftf1f23"1043"10000100"select text_int4($1)"- ));
2038+
DESCR("convert varchar to int4");
2039+
DATA(insertOID=1621 (textPGUID14ftf1f25"20"10000100"select int8_text($1)"- ));
2040+
DESCR("convert int8 to text");
2041+
DATA(insertOID=1622 (int8PGUID14ftf1f20"25"10000100"select text_int8($1)"- ));
2042+
DESCR("convert text to int8");
2043+
DATA(insertOID=1623 (varcharPGUID14ftf1f1043"20"10000100"select int8_text($1)"- ));
2044+
DESCR("convert int8 to varchar");
2045+
DATA(insertOID=1624 (int8PGUID14ftf1f20"1043"10000100"select text_int8($1)"- ));
2046+
DESCR("convert varchar to int8");
2047+
20302048
/* Oracle Compatibility Related Functions - By Edmund Mergl <E.Mergl@bawue.de> */
20312049
DATA(insertOID=868 (strposPGUID14ftf2f23"25 25"10000100"select textpos($1, $2)"- ));
20322050
DESCR("find position of substring");

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp