Join a varchar array - Mailing list pgsql-general

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 different rows but I would prefer to
get them back as an array.


regards
Robin