Casting output in postgresql

Question

I get as output ""10076053346"" in postgresql. This is in json format. I want to convert it into "10076053346" or this format 10076053346. So basically I want to convert it from json to int or text. I have tried out the various cast functions but they dont seem to be working for me. Any hints and help would be appreciated.

Kouber Saparev · Accepted Answer · 2014-12-08 15:18:51Z

1

You can trim the quotes and then cast to int TRIM(data, '"')::int, although the example value 10076053346 is out of the integer range, so you should go for a bigint or numeric instead.

SELECT TRIM(data, '"')::bigint;

answered Dec 8, 2014 at 15:18

Kouber Saparev

8,2552 gold badges32 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Casting output in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related