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
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.
Also I am very impressed with the response time for this help request!
Mark
>
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.
Perfect! Thanks for checking.
Looking forward to 1.10 beta.
Andreas
On Fri, February 27, 2009 2:34 pm, Guillaume Lelarge wrote:
> Andreas Neumann a écrit :
>> hm - I have Postgres 8.3.3 - so if it is already in Pgadmin3 1.8.4 - how
>> can I find this method?
>>
>
> It seems I was wrong. I don't
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
Andreas Neumann a écrit :
> hm - I have Postgres 8.3.3 - so if it is already in Pgadmin3 1.8.4 - how
> can I find this method?
>
It seems I was wrong. I don't find it in 1.8.4, but I find it in 1.9. So
you need to wait for 1.10 beta, which is expected next week.
> Should I find it in the context
Andreas Neumann a écrit :
> [...]
> It would be cool if one could interactively enabe/disable rules on
> individual tables (either all rules or selected rules), e.g. by
> right-clicking on the rule (context menu). I saw that there is a patch for
> this purpose
> (http://www.mail-archive.com/pgadmin
Hi,
It would be cool if one could interactively enabe/disable rules on
individual tables (either all rules or selected rules), e.g. by
right-clicking on the rule (context menu). I saw that there is a patch for
this purpose
(http://www.mail-archive.com/pgadmin-hack...@postgresql.org/msg10671.html)
