Script done... Function won´t work...
От
Marcel Boscher
Тема
Script done... Function won´t work...
Дата
Msg-id
4118E4F7.5070807@emedia-office.de
Список
Дерево обсуждения
Script done... Function won´t work... Marcel Boscher <mboscher@emedia-office.de>
Re: Script done. Mike G <mike@thegodshalls.com>
Re: Script done... Function won´t wo Ron St-Pierre <rstpierre@syscor.com>
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!!!! ...
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';
В списке pgsql-novice по дате отправления