Hi Thomas,
I knew, I had forgotten something... we are currently using
MaxDB 7.5.00.23 on Linux
Another weired thing:
I can create a Function using "create public function foo", I can use it and I can delete it with "drop public function foo". But after dropping it, I cant reuse that name with a new function. MaxDB tells me that the name would already be in use, but calling the function results in an error, because the function is not defined.
Thanks allot,
dirk
Anhaus, Thomas schrieb:
Hi Dirk, could you please tell me your MAXDB version ? Please keep in mind that user defined functions are released with 7.6.XX only !
Best Regards, Thomas
-----Ursprüngliche Nachricht-----
Von: Dirk Zugenmaier [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 1. März 2005 19:18
An: maxdb@lists.mysql.com
Betreff: Function gone/lost
Hi there,
hopefully someone can help me:
after creating a function as:
create public function TESTFUNC2 (FALLNR fixed(16)) RETURNS CHAR(1) AS IF
FALLNR < 99999999999 then return 'S'; if FALLNR < 99999999999999 then return 'A'
else return 'T';
I am unable to find the definition anywhere in my database. Without the "PUBLIC" it is stored in the dbfunctions-table, but this one I can't find, although I am able to use it?
Anyone got any clue?
Thanks in advance,
dirk zugenmaier
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?>[EMAIL PROTECTED]
-- ------------------------------- Universitätsklinikum Freiburg Klinikrechenzentrum, Abt. PDV Agnesenstr. 6-8 79106 Freiburg -------------------------------
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
