Problems with CREATE AGGREGATE and user defined state type.
Hello,
I discoverd what seems to be a bug in postgresql 7.4.12 (also on
7.4.7).
I have an example located at http://foo.fot.nu/psql/ with a simple
example that delevers the correct result on 8.1 (tested by some nice
person at #postgresql).
It seems like the state variable is reseted every time a new
grouped value pops up.
/M
--
Magnus Jonsson <bigfoot@acc.umu.se>
I'm here looking for an answer, but I'm not sure about the question...
delete my email from the list
Regards,
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Magnus Jonsson
Sent: Tuesday, March 21, 2006 8:39 PM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Problems with CREATE AGGREGATE and user defined state
type.
Hello,
I discoverd what seems to be a bug in postgresql 7.4.12 (also on
7.4.7).
I have an example located at http://foo.fot.nu/psql/ with a simple
example that delevers the correct result on 8.1 (tested by some nice
person at #postgresql).
It seems like the state variable is reseted every time a new
grouped value pops up.
/M
--
Magnus Jonsson <bigfoot@acc.umu.se>
I'm here looking for an answer, but I'm not sure about the question...
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
Magnus Jonsson <bigfoot@acc.umu.se> writes:
I discoverd what seems to be a bug in postgresql 7.4.12 (also on
7.4.7).
AFAIR, 7.4 and earlier didn't really have a sane way of representing
NULL composite-type values, so this aggregate isn't going to work
before 8.0.
regards, tom lane