Package: postgresql Version: 8.1.9 Severity: important After upgrade from 8.1.8 to 8.1.9 functions with "anyelement" return type stopped working, for example: CREATE FUNCTION if(boolean,anyelement,anyelement) RETURNS anyelement AS $$ SELECT CASE WHEN $1 THEN $2 ELSE $3 END; $$ LANGUAGE sql;
database=> SELECT IF(true, 0, 1) FROM sometable; ERROR: cannot display a value of type anyelement The bug was already reported upstream: http://www.nabble.com/Problems-with-%22anyelement%22-after-upgrading-from-8.1.4-to-8.1.9-t3823234.html And it seems it was fixed in upstream CVS: http://archives.postgresql.org/pgsql-committers/2007-05/msg00011.php -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-4-amd64 Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
