Not sure if this made it through before I subscribed, so...
Hello all,
before I ask, this is what I have done so far:
-- created this new aggregate function
CREATE AGGREGATE groupconcat_array (
SFUNC = array_append,
BASETYPE = anyelement,
STYPE = anyarray,
initcond = '{}'
);
-- ran
27;t. You'll need a single-argument finalfunc that hardwires the
delimiter, ie,
array_to_string($1, '|')
regards, tom lane
--
Ray Aspeitia
Sells Printing Company LLC
[EMAIL PROTECTED]
(262) 317-8314
---(end of broadcast)---
TIP
Hello,
I am running into some runtime differences that do not seem to make
sense and would like some help interpreting the EXPLAIN ANALYZE
output.
I have run 2 identical queries, one for each company. Company 1
returns 628 records in a time of 674ms and Company 2 returns 73
records in a time o
