2009/2/27 Dave Page :
>
> It's a bug - which is now fixed for the next release.
Thank you very much. The world has now become a better place ;-)
Regards,
Marcin
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
2009/2/27 Mark Pierce :
> I am a newbe with PostgreSQL and with pgAdmin so bare with me please. Below
> you list the steps to fix this issue but I need the steps before the "Now,
> click on created aggregate..." I can not locate this.
http://archives.postgresql.org/pgadmin-support/2009-02/msg00042
!
Mark
> Date: Fri, 27 Feb 2009 15:06:23 +
> Subject: Re: [pgadmin-support] aggregates' INITCOND='' doesn't display in SQL
> pane
> From: dp...@pgadmin.org
> To: mstepni...@gmail.com
> CC: pgadmin-support@postgresql.org
>
> On Fri, Feb 27, 2
On Fri, Feb 27, 2009 at 1:42 PM, Marcin Stępnicki wrote:
> 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.
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 s
