NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitabcc0ab

committed

Remove excess space from jsonpath .datetime() default format string

bffe1bd has introduced jsonpath .datetime() method, but default formatsfor time and timestamp contain excess space between time and timezone. Thiscommit removes this excess space making behavior of .datetime() methodstandard-compliant.Discussion:https://postgr.es/m/94321be0-cc96-1a81-b6df-796f437f7c66%40postgrespro.ruAuthor: Nikita GlukhovBackpatch-through: 13

1 parent059caf3 commitabcc0abCopy full SHA for abcc0ab

File tree

3 files changed

+80

-80

lines changed

src
- backend/utils/adt
  - jsonpath_exec.c
- test/regress
  - expected
    - jsonb_jsonpath.out
  - sql
    - jsonb_jsonpath.sql

3 files changed

+80

-80

lines changed

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

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1841,11 +1841,11 @@ executeDateTimeMethod(JsonPathExecContext cxt, JsonPathItem jsp,`
`1841`	`1841`	`staticconstchar*fmt_str[]=`
`1842`	`1842`	`{`
`1843`	`1843`	`"yyyy-mm-dd",`
`1844`		`-"HH24:MI:SS TZH:TZM",`
`1845`		`-"HH24:MI:SS TZH",`
	`1844`	`+"HH24:MI:SSTZH:TZM",`
	`1845`	`+"HH24:MI:SSTZH",`
`1846`	`1846`	`"HH24:MI:SS",`
`1847`		`-"yyyy-mm-dd HH24:MI:SS TZH:TZM",`
`1848`		`-"yyyy-mm-dd HH24:MI:SS TZH",`
	`1847`	`+"yyyy-mm-dd HH24:MI:SSTZH:TZM",`
	`1848`	`+"yyyy-mm-dd HH24:MI:SSTZH",`
`1849`	`1849`	`"yyyy-mm-dd HH24:MI:SS"`
`1850`	`1850`	`};`
`1851`	`1851`

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!

Commitabcc0ab

File tree

3 files changed

3 files changed

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

0 commit comments