Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

operator text ->> does not exist

Add Answer
Nixon Jimenez answered on March 14, 2023 Popularity 3/10 Helpfulness 1/10

Contents

  • answer operator text ->> does not exist

    • More Related Answers

  • operator does not exist: integer = text

    • operator text ->> does not exist

    Comment
    0

    The error message is pretty obvious: your column is defined as text not as jsonb or json. But the ->> operator only works with a jsonb or json column, so you will need to cast it: 

    Popularity 3/10 Helpfulness 1/10 Language sql
    Source: stackoverflow.com
    Tags: sql text
    Link to this answer
    Share Copy Link
    Nixon Jimenez
    Contributed on Mar 14 2023
    Nixon Jimenez
    0 Answers  Avg Quality 2/10

    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.