aggregates' INITCOND='' doesn't display in SQL pane - Mailing list pgadmin-support

From Marcin Stępnicki
Subject aggregates' INITCOND='' doesn't display in SQL pane
Date
Msg-id 179149fe0902270542v4ba8e2a1xf934446c26426ce1@mail.gmail.com
Whole thread Raw
Responses Re: aggregates' INITCOND='' doesn't display in SQL pane  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
Hello.

Let's create a simple, not very useful function and aggregate:

create or replace function strcat_pipe(text, text)
returns text as
$$ begin   if $1 = '' then     return $2;   else     return ( $1 || '| ' ) || $2;   end if; end;
$$ language plpgsql volatile;

create aggregate str_sum_pipe(text) ( SFUNC=strcat_pipe, STYPE=text, INITCOND = 'aaa'
);

Now, click on created aggregate and select CREATE SCRIPT. Change the
INITCOND to ''. Save, refresh and look at SQL Pane again. The INITCOND
is missing, which in this particular case means that our aggregate
will always return NULL.

pgAdmin III v. 1.8.2, rev 7032 from Ubuntu 8.04 + PostgreSQL 8.2.11.

Is it a bug or me doing something wrong?

Regards,
Marcin


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: enable/disable rules
Next
From: "Andreas Neumann"
Date:
Subject: Re: enable/disable rules