Commitb350600

committed

EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestamp

case for timestamptz input, and differently wrong answers in the float-timestamp case for timestamp input.

1 parentd61de58 commitb350600Copy full SHA for b350600

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 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/timestamp.c,v 1.71 2002/09/02 02:47:04 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.72 2002/09/03 22:55:54 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -2871,7 +2871,11 @@ timestamp_part(PG_FUNCTION_ARGS)`
`2871`	`2871`	`switch (val)`
`2872`	`2872`	`{`
`2873`	`2873`	`caseDTK_EPOCH:`
	`2874`	`+#ifdefHAVE_INT64_TIMESTAMP`
`2874`	`2875`	`result= ((timestamp-SetEpochTimestamp()) /1000000e0);`
	`2876`	`+#else`
	`2877`	`+result=timestamp-SetEpochTimestamp();`
	`2878`	`+#endif`
`2875`	`2879`	`break;`
`2876`	`2880`
`2877`	`2881`	`caseDTK_DOW:`
`@@ -3052,7 +3056,7 @@ timestamptz_part(PG_FUNCTION_ARGS)`
`3052`	`3056`	`{`
`3053`	`3057`	`caseDTK_EPOCH:`
`3054`	`3058`	`#ifdefHAVE_INT64_TIMESTAMP`
`3055`		`-result= ((timestamp-SetEpochTimestamp()) /100000e0);`
	`3059`	`+result= ((timestamp-SetEpochTimestamp()) /1000000e0);`
`3056`	`3060`	`#else`
`3057`	`3061`	`result=timestamp-SetEpochTimestamp();`
`3058`	`3062`	`#endif`

Comments

(0)