From: Greg Stark <gsstark@mit.edu>
To: Joe Conway <mail@joeconway.com>
Cc: miker@n2bb.com
Cc: pgsql-sql@postgresql.org
Subject: Re: casting to arrays
Date: 19 Jul 2003 19:11:30 -0400
Message-ID: <87lluu2jtp.fsf@stark.dyndns.tv> (raw)
In-Reply-To: <3F1867F3.7000109@joeconway.com>
References: <200307181707.48441.miker@n2bb.com>
<3F1867F3.7000109@joeconway.com>
Joe Conway <mail@joeconway.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gsstark@mit.edu, mail@joeconway.com, miker@n2bb.com
Subject: Re: casting to arrays
In-Reply-To: <87lluu2jtp.fsf@stark.dyndns.tv>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox