Hi all!
I'm having difficulty retrieving arrays from a view. I would like to get a Ruby
Array from a PostgreSQL array:
$ bundle exec sequel postgres:///svanalytics_development
Your database is stored in DB...
> require "pp"
> require "sequel/extensions/pg_array"
> DB.extension :pg_array
> pp DB[:show_channels].filter("array_upper(channel_ids, 1) > 1").first
{:start_at=>2012-02-22 05:00:00 -0500,
:interval=>"1 day",
:market_id=>"d4c13fb0-db2c-012e-ebb6-40400fe46aa7",
:show_id=>"71684e92-daec-11e0-9b8e-40402761cfca",
:name=>"Canada Québec",
:show_name=>"RDI Matin",
:channel_ids=>
"{71bfd2e8-daec-11e0-9b8e-40402761cfca,71bfd61c-daec-11e0-9b8e-40402761cfca}"}
Note channel_ids is a string literal of an array, instead of a plain-old Ruby
Array. show_channels is a view with this schema:
Column | Type | Modifiers | Storage | Description
-------------+--------------------------+-----------+----------+-------------
start_at | timestamp with time zone | | plain |
interval | interval | | plain |
market_id | uuid | | plain |
show_id | uuid | | plain |
name | character varying(96) | | extended |
show_name | character varying(96) | | extended |
channel_ids | uuid[] | | extended |
I use Ruby 1.9.3, PostgreSQL 9.1.5 and
$ bundle show | grep -E '(pg|sequel)'
* pg (0.16.0)
* sequel (3.48.0)
* sequel_pg (1.6.8)
I suspect it's something really simple, but I'm not seeing it... The docs at
http://sequel.rubyforge.org/rdoc-plugins/files/lib/sequel/extensions/pg_array_rb.html
do say: "... integrates with Sequel's native postgres adapter, so that when
array fields are retrieved, they are parsed and returned as instances of
Sequel::Postgres::PGArray." I believe this is exactly what I'm doing, but
something's wrong on my end.
I tried Sequel 4.1.1, and channel_ids is still returned as a String.
Thanks!
François
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
