diff options
| author | Yves Senn <yves.senn@gmail.com> | 2014-09-03 08:59:52 +0200 |
|---|---|---|
| committer | Yves Senn <yves.senn@gmail.com> | 2014-09-03 08:59:52 +0200 |
| commit | f6d3af4fa7e6dea228475ac142fa28288807fcc9 (patch) | |
| tree | fced9a8fd14abb93f2c787f007e9acdcbde27e1d /guides/source | |
| parent | ea1a02878cc41294d7a960e183301e6fb9784a15 (diff) | |
| parent | 6d988e2a29fa898176adeef6936e6032a221e4fd (diff) | |
| download | rails-f6d3af4fa7e6dea228475ac142fa28288807fcc9.tar.gz rails-f6d3af4fa7e6dea228475ac142fa28288807fcc9.tar.bz2 rails-f6d3af4fa7e6dea228475ac142fa28288807fcc9.zip | |
Merge pull request #16780 from viditn91/use-correct-operators-in-query
use correct operator in query based on JSON document [ci skip]
Diffstat (limited to 'guides/source')
| -rw-r--r-- | guides/source/active_record_postgresql.md | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/guides/source/active_record_postgresql.md b/guides/source/active_record_postgresql.md index a5649e3903..6c94218ef6 100644 --- a/guides/source/active_record_postgresql.md +++ b/guides/source/active_record_postgresql.md @@ -132,7 +132,8 @@ event = Event.first event.payload # => {"kind"=>"user_renamed", "change"=>["jack", "john"]} ## Query based on JSON document -Event.where("payload->'kind' = ?", "user_renamed") +# The -> operator returns the original JSON type (which might be an object), whereas ->> returns text +Event.where("payload->>'kind' = ?", "user_renamed") ``` ### Range Types |