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 |/
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 ? |