Re: [HACKERS] Problems with CREATE AGGREGATE and user defined state type.

2006-03-21 Thread Tom Lane
Magnus Jonsson <[EMAIL PROTECTED]> 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. regar

[HACKERS] Problems with CREATE AGGREGATE and user defined state type.

2006-03-21 Thread Magnus Jonsson
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

Re: [HACKERS] Problems with CREATE AGGREGATE and user defined state type.

2006-03-21 Thread Aftab Alam
delete my email from the list Regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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