diff options
| author | Yves Senn <yves.senn@gmail.com> | 2016-01-18 10:18:46 +0100 |
|---|---|---|
| committer | Yves Senn <yves.senn@gmail.com> | 2016-01-18 10:18:46 +0100 |
| commit | 091b1ab58e2b24fdc1eb7549fe2f8f02e80bd2a9 (patch) | |
| tree | c267c99bdafb95309cf1d1fb1aacd72b4ef98abf /guides/source | |
| parent | 3bb6b7c7139eee36568f4f0e5a7a913ea2531872 (diff) | |
| parent | ad08072249f85732abe4de408a0316c6b7bfaa99 (diff) | |
| download | rails-091b1ab58e2b24fdc1eb7549fe2f8f02e80bd2a9.tar.gz rails-091b1ab58e2b24fdc1eb7549fe2f8f02e80bd2a9.tar.bz2 rails-091b1ab58e2b24fdc1eb7549fe2f8f02e80bd2a9.zip | |
Merge pull request #23097 from prathamesh-sonpatki/psql-hstore
Explain how HStore columns can be queried [ci skip]
Diffstat (limited to 'guides/source')
| -rw-r--r-- | guides/source/active_record_postgresql.md | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/guides/source/active_record_postgresql.md b/guides/source/active_record_postgresql.md index b592209d4b..68c6a77882 100644 --- a/guides/source/active_record_postgresql.md +++ b/guides/source/active_record_postgresql.md @@ -84,6 +84,7 @@ Book.where("array_length(ratings, 1) >= 3") ### Hstore * [type definition](http://www.postgresql.org/docs/current/static/hstore.html) +* [functions and operators](http://www.postgresql.org/docs/current/static/hstore.html#AEN167712) NOTE: You need to enable the `hstore` extension to use hstore. @@ -108,6 +109,9 @@ profile.settings # => {"color"=>"blue", "resolution"=>"800x600"} profile.settings = {"color" => "yellow", "resolution" => "1280x1024"} profile.save! + +Profile.where("settings->'color' = ?", "yellow") +#=> #<ActiveRecord::Relation [#<Profile id: 1, settings: {"color"=>"yellow", "resolution"=>"1280x1024"}>]> ``` ### JSON |