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

Commit1c25c52

Browse files
committed
Add missing pg_proc entry for interval_scale(). The lack of this entry
causes interval rounding not to work as expected in 7.3, for exampleSELECT '18:17:15.6'::interval(0) does not round the value.I did not force initdb, but one is needed to install the added row.
1 parent7aa2038 commit1c25c52

File tree

1 file changed

+6
-3
lines changed

1 file changed

+6
-3
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_proc.h,v 1.280 2002/12/12 21:02:25 momjian Exp $
10+
* $Id: pg_proc.h,v 1.281 2003/01/09 00:58:41 tgl Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -1494,6 +1494,9 @@ DESCR("date difference preserving months and years");
14941494

14951495
/* OIDS 1200 - 1299 */
14961496

1497+
DATA(insertOID=1200 (intervalPGNSPPGUID12fftfi21186"1186 23"interval_scale-_null_ ));
1498+
DESCR("adjust interval precision");
1499+
14971500
DATA(insertOID=1215 (obj_descriptionPGNSPPGUID14fftfs225"26 19""select description from pg_description where objoid = $1 and classoid = (select oid from pg_class where relname = $2 and relnamespace = PGNSP) and objsubid = 0"-_null_ ));
14981501
DESCR("get description for object id and catalog name");
14991502
DATA(insertOID=1216 (col_descriptionPGNSPPGUID14fftfs225"26 23""select description from pg_description where objoid = $1 and classoid = \'pg_catalog.pg_class\'::regclass and objsubid = $2"-_null_ ));
@@ -2774,15 +2777,15 @@ DATA(insert OID = 1954 ( byteacmp PGNSP PGUID 12 f f t f i 2 23 "17 17"byt
27742777
DESCR("less-equal-greater");
27752778

27762779
DATA(insertOID=1961 (timestampPGNSPPGUID12fftfi21114"1114 23"timestamp_scale-_null_ ));
2777-
DESCR("adjusttime precision");
2780+
DESCR("adjusttimestamp precision");
27782781

27792782
DATA(insertOID=1965 (oidlargerPGNSPPGUID12fftfi226"26 26"oidlarger-_null_ ));
27802783
DESCR("larger of two");
27812784
DATA(insertOID=1966 (oidsmallerPGNSPPGUID12fftfi226"26 26"oidsmaller-_null_ ));
27822785
DESCR("smaller of two");
27832786

27842787
DATA(insertOID=1967 (timestamptzPGNSPPGUID12fftfi21184"1184 23"timestamptz_scale-_null_ ));
2785-
DESCR("adjusttime precision");
2788+
DESCR("adjusttimestamp precision");
27862789
DATA(insertOID=1968 (timePGNSPPGUID12fftfi21083"1083 23"time_scale-_null_ ));
27872790
DESCR("adjust time precision");
27882791
DATA(insertOID=1969 (timetzPGNSPPGUID12fftfi21266"1266 23"timetz_scale-_null_ ));

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp