Re: generic way to retrieve array as rowset

From: Greg Stark <gsstark(at)mit(dot)edu>
To: SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: generic way to retrieve array as rowset
Date: 2006-01-03 23:19:12
Message-ID: 87ek3o6gsv.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu> writes:

> Thank you both, I will make good use of this.
>
> On a side note: isn't it a pity this has to be so difficult?

It doesn't have to be.

Look in the contrib directory, build the intagg module (or if you use debian
install the postgresql-contrib package) and then:

SELECT id, int_array_enum(val) FROM t7

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2006-01-03 23:52:24 Re: [Pgsqlrpms-hackers] Re: DBlink documentation
Previous Message Tom Lane 2006-01-03 22:50:04 Re: [GENERAL] PL/pgSQL Function Help