arrays as arrays?

Joshua N Pritikin <[email protected]>
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
If I try to SELECT a whole array then I receive a string like:

  '[0:4]={0.5,0.5,0.0643077,0.184699,0.5}'

Is there a way for DBD::Pg to convert this into a perl array for me? 
Otherwise I have to do something rather tedious:

select member_lang_quality[0] as q0, member_lang_quality[1] as q1,
  member_lang_quality[2] as q2, member_lang_quality[3] as q3,
  member_lang_quality[4] as q4,
  member_lang_samples[0] as s0, member_lang_samples[1] as s1,
  member_lang_samples[2] as s2, member_lang_samples[3] as s3,
  member_lang_samples[4] as s4
from member_lang
where member_id = ? and member_lang = ?

This could be automated but letting DBD::Pg do the conversion would seem 
a lot cleaner.

-- 
Make April 15 just another day, visit http://fairtax.org
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.