How to select JSON value as int in PostgreSQL? [duplicate]

Question

I've a value of jsonb which has a key that contains an int.

I'd like to insert this into a table with an int column. I get an error of ERROR: column "abr" is of type integer but expression is of type text LINE 4: values->>'abr' as abr,

select
  values->>'_filename' as _filename,
  values->>'abr' as abr
from   temp_json;

How can I select the value with a key of abr as an int?

Chris Stryczynski · Accepted Answer · 2017-07-10 10:43:45Z

2

This works:

select
  values->>'_filename' as _filename,
  (values->>'abr')::int as abr
from   temp_json;

answered Jul 10, 2017 at 10:43

Chris Stryczynski

34.8k60 gold badges210 silver badges334 bronze badges

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

Collectives™ on Stack Overflow

How to select JSON value as int in PostgreSQL? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related