Re: Script done. - Mailing list pgsql-novice

From Mike G
Subject Re: Script done.
Date
Msg-id 20040811041115.GC19602@localhost.localdomain
Whole thread Raw
In response to Script done... Function won´t work...  (Marcel Boscher <mboscher@emedia-office.de>)
List pgsql-novice
Hello,
I believe you need to call your function as pass an int everytime.

SELECT zufall(0);

If you have multiple databases, not in schema sense, make sure you clicked somewhere on the screen within that database
sothe sql window points to that database. 

Mike

On Tue, Aug 10, 2004 at 05:08:39PM +0200, Marcel Boscher wrote:
> Once again, ;-)
>
> The script is finally done i hope ...
>
> i can create my function.... no problem
> but when i'm calling it up with a
> SELECT zufall(); statement pgAdmin
> tells me there is no function with that name...
> although its listed in my function list as zufall!!!! ...
> <runningagainstthewallheadfirst>
>
>
> SOURCE:
> create or replace function zufall(int4) returns text as '
> declare
>  anzahl      alias for $1;
>  i           int4;
>  zeichen     char(1);
>  zufallstext text;
>  entries     int8;
> begin
>  loop
>    zufallstext := '''';
>    for i in 1..anzahl loop
>      select chr(trunc((random()*26)+65)) into zeichen;
>      zufallstext := zufallstext || zeichen;
>    end loop;
>    SELECT count(*) into entries FROM se_errorcode
>      WHERE entry = zufallstext;
>    EXIT WHEN entries = 0;
>  end loop;
>  return zufallstext;
> end;
> ' language 'plpgsql';
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly

pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What constitutes a pgsql session?
Next
From: Mike G
Date:
Subject: Re: New installation of 8.0 Beta1 Failed to create process for initdb: 1385