Commitf7a51b7

committed

Cleanup of to_char() patch.

Brendan Jurd

1 parentc6ed4ea commitf7a51b7Copy full SHA for f7a51b7

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`	`/* -----------------------------------------------------------------------`
`2`	`2`	`* formatting.c`
`3`	`3`	`*`
`4`		`- * $PostgreSQL: pgsql/src/backend/utils/adt/formatting.c,v 1.126 2007/02/16 10:55:47 petere Exp $`
	`4`	`+ * $PostgreSQL: pgsql/src/backend/utils/adt/formatting.c,v 1.127 2007/02/17 01:51:42 momjian Exp $`
`5`	`5`	`*`
`6`	`6`	`*`
`7`	`7`	`* Portions Copyright (c) 1999-2007, PostgreSQL Global Development Group`
`@@ -16,8 +16,9 @@`
`16`	`16`	`* Cache & Memory:`
`17`	`17`	`*Routines use (itself) internal cache for format pictures.`
`18`	`18`	`*`
`19`		`- *The cache uses a static buffers and is persistent across transactions.`
`20`		`- *If format-picture is bigger than cache buffer, parser is called always.`
	`19`	`+ *The cache uses a static buffer and is persistent across transactions. If`
	`20`	`+ *the format-picture is bigger than the cache buffer, the parser is called`
	`21`	`+ *always.`
`21`	`22`	`*`
`22`	`23`	`* NOTE for Number version:`
`23`	`24`	`*All in this version is implemented as keywords ( => not used`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -720,11 +720,11 @@ SELECT '' AS "54", d1 as timestamptz,`
`720`	`720`	`\| Mon Jan 01 17:32:01 2001 PST \| 1 \| 1000 \| 1000000`
`721`	`721`	`(56 rows)`
`722`	`722`
`723`		`-SELECT '' AS "54", d1 as"timestamp",`
	`723`	`+SELECT '' AS "54", d1 astimestamptz,`
`724`	`724`	`date_part( 'isoyear', d1) AS isoyear, date_part( 'week', d1) AS week,`
`725`	`725`	`date_part( 'dow', d1) AS dow`
`726`	`726`	`FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';`
`727`		`- 54 \|timestamp \| isoyear \| week \| dow`
	`727`	`+ 54 \|timestamptz \| isoyear \| week \| dow`
`728`	`728`	`----+---------------------------------+---------+------+-----`
`729`	`729`	`\| Wed Dec 31 16:00:00 1969 PST \| 1970 \| 1 \| 3`
`730`	`730`	`\| Mon Feb 10 17:32:01 1997 PST \| 1997 \| 7 \| 1`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -169,7 +169,7 @@ SELECT '' AS "54", d1 as timestamptz,`
`169`	`169`	`date_part('usec', d1)AS usec`
`170`	`170`	`FROM TIMESTAMPTZ_TBLWHERE d1 BETWEEN'1902-01-01'AND'2038-01-01';`
`171`	`171`
`172`		`-SELECT''AS"54", d1as"timestamp",`
	`172`	`+SELECT''AS"54", d1astimestamptz,`
`173`	`173`	`date_part('isoyear', d1)AS isoyear, date_part('week', d1)AS week,`
`174`	`174`	`date_part('dow', d1)AS dow`
`175`	`175`	`FROM TIMESTAMPTZ_TBLWHERE d1 BETWEEN'1902-01-01'AND'2038-01-01';`

Comments

(0)