pg_dump of regression (again)

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-hackers(at)hub(dot)org
Subject: pg_dump of regression (again)
Date: 2000-09-14 11:09:49
Message-ID: 3.0.5.32.20000914210949.036e13d0@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Continuing to try to use format_type to output all types, I get the
following in the regression database:

CREATE AGGREGATE newavg (
BASETYPE = integer,
SFUNC = int4_accum,
STYPE = "numeric[]",
INITCOND = '{0,0,0}',
FINALFUNC = numeric_avg
);

where the original source was:

CREATE AGGREGATE newavg (
sfunc = int4_accum, basetype = int4,
stype = _numeric,
finalfunc = numeric_avg,
initcond1 = '{0,0,0}'
);

The problem is the "numeric[]" type. Does this mean I should go back to
just using typnam for aggregates? For all but table definitions? Or is
there an alternate solution.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-09-14 12:01:50 Re: List funnies ?
Previous Message Zeljko Trogrlic 2000-09-14 10:49:18 RE: [HACKERS] List funnies ?