Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- '[1,2,3]'::json->2 as "->",
- pg_typeof('[1,2,3]'::json->2) as "-> type",
- '[1,2,3]'::json->>2 as "-->",
- pg_typeof('[1,2,3]'::json->>2) as "--> type"
- ;
- -> | -> type | --> | --> type
- ----+---------+-----+----------
- 3 | json | 3 | text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement