Re: generic way to retrieve array as rowset - Mailing list pgsql-general

SunWuKung <Balazs.Klein@axelero.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