NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commit9524c6b

committed

Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison

of timetz values misbehaved in --enable-integer-datetime cases, andEXTRACT(EPOCH) subtracted the zone instead of adding it in all cases.Backpatch to all supported releases (except --enable-integer-datetime codedoes not exist in 7.2).

1 parent6fbda16 commit9524c6bCopy full SHA for 9524c6b

File tree

1 file changed

-2

lines changed

src/backend/utils/adt
- date.c

1 file changed

-2

lines changed

`‎src/backend/utils/adt/date.c`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64.2.3 2002/09/30 20:57:10 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.64.2.4 2005/04/23 22:54:23 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -1553,7 +1553,7 @@ timetz_part(PG_FUNCTION_ARGS)`
`1553`	`1553`	`}`
`1554`	`1554`	`}`
`1555`	`1555`	`elseif ((type==RESERV)&& (val==DTK_EPOCH))`
`1556`		`-result=time->time-time->zone;`
	`1556`	`+result=time->time+time->zone;`
`1557`	`1557`	`else`
`1558`	`1558`	`{`
`1559`	`1559`	`elog(ERROR,"TIMETZ units '%s' not recognized",`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit9524c6b

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/date.c`

0 commit comments