Verify yourself to prove that you are not a ROBOT! After verification the page will apear. Thanks for understanding.
I have a jsonb called data.
I have to check if data->>'id' is null.
If its null then we set to a boolean variable called hasid to false and vice versa.
So how do I write this?
I tried using coalesce but got issues with matching different data types.
Anyone knows how?
id is integer but I'm getting it as text via ->>.
I tried ->, when its not null it will be comparing with jsonb type.