[GENERAL] Join a varchar array

2004-06-17 Thread Robin Ericsson
Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table? I don't mind getting them on

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Richard Huxton
Robin Ericsson wrote: Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table? You appear

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Robin Ericsson
On Thu, 2004-06-17 at 11:38, Richard Huxton wrote: Robin Ericsson wrote: Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Richard Huxton
Robin Ericsson wrote: On Thu, 2004-06-17 at 11:38, Richard Huxton wrote: You appear to be using the array as a replacement for a table. Don't do that. From the little information you've provided, it looks like you want a separate table (a_ref, b_ref, float_val) where a_ref references the