| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | miker(at)n2bb(dot)com, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: casting to arrays |
| Date: | 2003-07-19 23:11:30 |
| Message-ID: | 87lluu2jtp.fsf@stark.dyndns.tv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Joe Conway <mail(at)joeconway(dot)com> writes:
> Not possible in current releases, but it will be in 7.4 (about to start beta).
> It looks like this:
Well there is the int_array_aggregate function in the contrib/intagg
directory. It has to be compiled separately, and it has a few quirks (like the
arrays are zero-based instead of 1-based) but it works more or less, and it
does exactly what you describe.
But the 7.4 stuff should be much cleaner and more flexible, so if you don't
need it right now you're better off waiting.
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-07-20 03:04:20 | Re: How access to array component |
| Previous Message | Philip Warner | 2003-07-19 14:23:51 | Re: plpgsql strangeness with select into <variable> |