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