How to convert postgres json to integer

by

What works for me (using posgtgresql 5.6) is 

SELECT (tablename.jsoncolumnname->>'jsonfiledname')::int FROM tablename;

like

SELECT (users.data->>'failed_login_attempts_count')::int FROM users;

Assuming users table has a json column named data which is something like: 

{"failed_login_attempts_count":"2","comment":"VIP"}

More Related Contents:

  1. How do I modify fields inside the new PostgreSQL JSON datatype?
  2. Flatten aggregated key/value pairs from a JSONB field?
  3. Explanation of JSONB introduced by PostgreSQL
  4. Postgres: How to convert a json string to text?
  5. How to query a json column for empty objects?
  6. PostgreSQL return result set as JSON array?
  7. How to create index on JSON field in Postgres?
  8. Postgres JSON data type Rails query
  9. Check if a Postgres JSON array contains a string
  10. Merging JSONB values in PostgreSQL?
  11. Collect Recursive JSON Keys In Postgres
  12. Size limit of JSON data type in PostgreSQL
  13. In postgresql, how can I return a boolean value instead of string on a jsonb key?
  14. How do I get ASP.NET Web API to return JSON instead of XML using Chrome?
  15. Posting a File and Associated Data to a RESTful WebService preferably as JSON
  16. How to convert arbitrary simple JSON to CSV using jq?
  17. My structures are not marshalling into json [duplicate]
  18. Excel VBA: Parsed JSON Object Loop
  19. Using curl POST with variables defined in bash script functions
  20. Standardized way to serialize JSON to query string?
  21. How can I customize serialization of a list of JAXB objects to JSON?
  22. How to use default serialization in a custom JsonConverter
  23. Map JSON data to Knockout observableArray with specific view model type
  24. How to add properties to topojson file?
  25. jqGrid returns blank cells
  26. How to receive JSON in a POST request in CherryPy?
  27. Unable to find a MessageBodyReader of content-type application/json and type class java.lang.String
  28. Can anyone explain how to get all the mismatch between two responses in karate?
  29. How to pass payload via JSON file for curl?
  30. Constructing a JSON object from a bash associative array

Leave a Comment