NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitd74c52c

Thomas G. Lockhart

committed

Allow more timezone-like interpretation of INTERVALs.

1 parenta669bd7 commitd74c52cCopy full SHA for d74c52c

File tree

1 file changed

+20

-20

lines changed

src/test/regress/expected
- interval.out

1 file changed

+20

-20

lines changed

`‎src/test/regress/expected/interval.out`

Lines changed: 20 additions & 20 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,44 +3,44 @@`
`3`	`3`	`--`
`4`	`4`	`SET DATESTYLE = DEFAULT;`
`5`	`5`	`-- check acceptance of "time zone style"`
`6`		`-SELECT INTERVAL '01:00';`
`7`		`-?column?`
	`6`	`+SELECT INTERVAL '01:00' AS "One hour";`
	`7`	`+One hour`
`8`	`8`	`----------`
`9`	`9`	`+01:00`
`10`	`10`	`(1 row)`
`11`	`11`
`12`		`-SELECT INTERVAL '+02:00';`
`13`		`-?column?`
`14`		`-----------`
	`12`	`+SELECT INTERVAL '+02:00' AS "Two hours";`
	`13`	`+Two hours`
	`14`	`+-----------`
`15`	`15`	`+02:00`
`16`	`16`	`(1 row)`
`17`	`17`
`18`		`-SELECT INTERVAL '-08:00';`
`19`		`-?column?`
`20`		`-----------`
	`18`	`+SELECT INTERVAL '-08:00' AS "Eight hours";`
	`19`	`+Eight hours`
	`20`	`+-------------`
`21`	`21`	`-08:00`
`22`	`22`	`(1 row)`
`23`	`23`
`24`		`-SELECT INTERVAL '-05';`
`25`		`-?column?`
`26`		`------------`
`27`		`- -00:00:05`
	`24`	`+SELECT INTERVAL '-05' AS "Five hours";`
	`25`	`+Five hours`
	`26`	`+------------`
	`27`	`+ -05:00`
`28`	`28`	`(1 row)`
`29`	`29`
`30`		`-SELECT INTERVAL '-1 +02:03';`
`31`		`-?column?`
`32`		`-----------`
	`30`	`+SELECT INTERVAL '-1 +02:03' AS "22 hours ago...";`
	`31`	`+22 hours ago...`
	`32`	`+-----------------`
`33`	`33`	`-21:57`
`34`	`34`	`(1 row)`
`35`	`35`
`36`		`-SELECT INTERVAL '-1 days +02:03';`
`37`		`-?column?`
`38`		`-----------`
	`36`	`+SELECT INTERVAL '-1 days +02:03' AS "22 hours ago...";`
	`37`	`+22 hours ago...`
	`38`	`+-----------------`
`39`	`39`	`-21:57`
`40`	`40`	`(1 row)`
`41`	`41`
`42`		`-SELECT INTERVAL '10 years -11 month -12 days +13:14';`
`43`		`- ?column?`
	`42`	`+SELECT INTERVAL '10 years -11 month -12 days +13:14' AS "9 years...";`
	`43`	`+9 years...`
`44`	`44`	`--------------------------`
`45`	`45`	`9 years 1 mon -11 -10:46`
`46`	`46`	`(1 row)`

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!

Commitd74c52c

File tree

1 file changed

1 file changed

`‎src/test/regress/expected/interval.out`

0 commit comments