Script done... Function won´t work...
От | Marcel Boscher |
---|---|
Тема | Script done... Function won´t work... |
Дата | |
Msg-id | 4118E4F7.5070807@emedia-office.de обсуждение исходный текст |
Ответы |
Re: Script done... Function won´t wo
Re: Script done. |
Список | pgsql-novice |
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';
В списке pgsql-novice по дате отправления: