Re: [GENERAL] Running multiple versions

2012-01-05 Thread prakashn
> > So assuming all this is done in regular userland. built from source > etc, you'll need to do a couple things. Each version needs to be > built with a different --prefix. I prefer something like > --prefix=/home/myusername/pg83 and --prefix=/home/myusername/pg91 and > so on. This will put the

[GENERAL] Relative ordering in array aggregation

2011-02-09 Thread prakashn
I'm using 8.3.3. I came across the array_accum aggregate function in the docs: http://www.postgresql.org/docs/8.3/interactive/xaggr.html CREATE AGGREGATE array_accum (anyelement) ( sfunc = array_append, stype = anyarray, initcond = '{}' ); This would be very useful to me, but I ha