NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitc2aa562

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 parentfd26f78 commitc2aa562Copy full SHA for c2aa562

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
`@@ -1837,11 +1837,11 @@ executeDateTimeMethod(JsonPathExecContext cxt, JsonPathItem jsp,`
`1837`	`1837`	`staticconstchar*fmt_str[]=`
`1838`	`1838`	`{`
`1839`	`1839`	`"yyyy-mm-dd",`
`1840`		`-"HH24:MI:SS TZH:TZM",`
`1841`		`-"HH24:MI:SS TZH",`
	`1840`	`+"HH24:MI:SSTZH:TZM",`
	`1841`	`+"HH24:MI:SSTZH",`
`1842`	`1842`	`"HH24:MI:SS",`
`1843`		`-"yyyy-mm-dd HH24:MI:SS TZH:TZM",`
`1844`		`-"yyyy-mm-dd HH24:MI:SS TZH",`
	`1843`	`+"yyyy-mm-dd HH24:MI:SSTZH:TZM",`
	`1844`	`+"yyyy-mm-dd HH24:MI:SSTZH",`
`1845`	`1845`	`"yyyy-mm-dd HH24:MI:SS"`
`1846`	`1846`	`};`
`1847`	`1847`

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!

Commitc2aa562

File tree

3 files changed

3 files changed

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

0 commit comments