Re: generic way to retrieve array as rowset

From: SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: generic way to retrieve array as rowset
Date: 2006-01-04 12:23:45
Message-ID: MPG.1e25dcbf1df8a2e1989685@news.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <87ek3o6gsv(dot)fsf(at)stark(dot)xeocode(dot)com>, gsstark(at)mit(dot)edu says...
>
> 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
>
>
Unfortunately I now work on a popular, but cripled proprietary system
with no C compiler (WinXP), so I don't think I can make use of that yet
- I will change though (one of those new year wows).

Thanks.
B.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ctobini 2006-01-04 12:55:49 Re: postgresql7.4 can't start (SSL)
Previous Message DANTE ALEXANDRA 2006-01-04 11:04:28 Anyone doing a 8.1.0-ia64-RHEL4-as.rpm ?