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

Commit1f14a9d

Browse files
committed
Correct broken entries for pg_proc OIDs 1364 (time(abstime))
and 1370 (timestamp(datetime)). This does not force an initdb, exactly,but you won't see the effects of the bug fix until you do one.BTW, OID 1358 for timespan(time) is still broken:select timespan('21:11:26'::time);ERROR: No such function 'time_timespan' with the specified attributesBut I couldn't figure out what it ought to be defined as, so I left it be.
1 parent9202c4f commit1f14a9d

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 3 additions & 3 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.100 1999/07/15 23:03:43 momjian Exp $
9+
* $Id: pg_proc.h,v 1.101 1999/08/29 01:35:11 tgl Exp $
1010
*
1111
* NOTES
1212
* The script catalog/genbki.sh reads this file and generates .bki
@@ -1641,7 +1641,7 @@ DATA(insert OID = 1362 ( time PGUID 14 f t f 1 f 1083 "1083" 100 0 0 100 "
16411641
DESCR("convert (noop)");
16421642
DATA(insertOID=1363 (timePGUID11ftf1f1083"1184"10000100datetime_time- ));
16431643
DESCR("convert datetime to time");
1644-
DATA(insertOID=1364 (timePGUID14ftf1f1083"702"10000100"selectabstime_time($1)"- ));
1644+
DATA(insertOID=1364 (timePGUID14ftf1f1083"702"10000100"selecttime(datetime($1))"- ));
16451645
DESCR("convert abstime to time");
16461646
DATA(insertOID=1365 (abstimePGUID14ftf1f702"702"10000100"select $1"- ));
16471647
DESCR("convert (noop)");
@@ -1653,7 +1653,7 @@ DATA(insert OID = 1368 ( reltime PGUID 11 f t f 1 f 703 "1186" 100 0 0 100
16531653
DESCR("convert timespan to reltime");
16541654
DATA(insertOID=1369 (timestampPGUID14ftf1f1296"1296"10000100"select $1"- ));
16551655
DESCR("convert (noop)");
1656-
DATA(insertOID=1370 (timestampPGUID14ftf1f1296"1184"10000100"select datetime_stamp($1)"- ));
1656+
DATA(insertOID=1370 (timestampPGUID11ftf1f1296"1184"10000100datetime_timestamp- ));
16571657
DESCR("convert datetime to timestamp");
16581658
DATA(insertOID=1371 (lengthPGUID11ftf1f23"25"10000100textlen- ));
16591659
DESCR("character length");

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp