Join a varchar array

From: Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Join a varchar array
Date: 2004-06-17 08:39:29
Message-ID: 1087461569.19169.83.camel@cdontest.noname4us.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zuhans@iname.com 2004-06-17 09:04:19 Re: why no answer? [Fwd: backup and restore just with use
Previous Message Csaba Nagy 2004-06-17 08:03:30 Re: Tracking down deadlocks