|
Home > Archive > PostgreSQL Hacks > March 2006 > Problems with CREATE AGGREGATE and user defined state type.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problems with CREATE AGGREGATE and user defined state type.
|
|
| Magnus Jonsson 2006-03-21, 11:32 am |
|
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?
http://www.postgresql.org/docs/faq
| |
| Aftab Alam 2006-03-21, 11:32 am |
| 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?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Tom Lane 2006-03-21, 11:32 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|