What is the difference between ->>
and ->
in SQL?
In this thread (Check if field exists in json type column postgresql), the answerer basically recommends using,
json->'attribute' is not null
instead of,
json->>'attribute' is not null
Why use a single arrow instead of a double arrow? In my limited experience, both do the same thing.
See Question&Answers more detail:os