>
>, as far as i can see, from mysql 5.0 and upper it is possible create
>index using functions.
>
>http://www.faqs.org/docs/ppbook/r24254.htm
>
>But i keep having problems with the exemple from the link. Is there any bug
>in mysql 5.0.24a-log?
The above website says:
"Practical PostgreSQL"
, as far as i can see, from mysql 5.0 and upper it is possible create
index using functions.
http://www.faqs.org/docs/ppbook/r24254.htm
But i keep having problems with the exemple from the link. Is there any bug
in mysql 5.0.24a-log?
2007/11/13, Martijn Tonies <[EMAIL PROTECTED]>:
>mysql>
Hi
I've created a function that return a float value the code for it is :
create function IDR(pin1 varchar(20),pin4 varchar(20),pin6 varchar(20),pin7
varchar(20),pin9 varchar(20),MOL varchar(20)) returns float
DETERMINISTIC
begin
declare output float;
>mysql> create index AA on precalc (IDR(P1,P4,P6,P7,P9,'HLA-DRB13'));
>
>But i Get the following error:
>
>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
>that corresponds to your MySQL server version for the right syntax to use
>near ''P1','P4','P6','P7','P9','HLA-DRB1
Hi
I've created a function that return a float value the code for it is :
create function IDR(pin1 varchar(20),pin4 varchar(20),pin6 varchar(20),pin7
varchar(20),pin9 varchar(20),MOL varchar(20)) returns float
DETERMINISTIC
begin
declare output float;
