--On mardi 21 mai 2002 10:19 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
> Mathieu Arnold <[EMAIL PROTECTED]> writes:
>> when I dump my database, in the dump file, the aggregate becomes :
>
>> CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE =
>> text, INITCOND = '' );
>
> Ooop
Mathieu Arnold <[EMAIL PROTECTED]> writes:
> when I dump my database, in the dump file, the aggregate becomes :
> CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = text,
> INITCOND = '' );
Ooops. This seems to be fixed already in current sources, but I think
a back-patch to
Hi
I have :
CREATE FUNCTION "first_cat" (text,text) RETURNS text AS 'SELECT CASE WHEN
$1 IS NULL THEN $2 ELSE $1 END' LANGUAGE 'sql';
and :
CREATE AGGREGATE first ( BASETYPE = text, SFUNC = first_cat, STYPE = text);
when I dump my database, in the dump file, the aggregate becomes :
CREATE A