Re: Index key on yearweek(date)

2005-02-21 Thread Gleb Paharenko
Hello. No, you can't. But you can make some workarounds. For example you may use triggers in 5.0.2 version (but it is still not production ready) or use a separate field for storing the value of the week. Hany Nagaty [EMAIL PROTECTED] wrote: Hi all, I'm a bit new to MySQL, it's

Index key on yearweek(date)

2005-02-18 Thread Hany Nagaty
Hi all, I'm a bit new to MySQL, it's my first email to the list. Well, my question is: Can I have a key on a function of the column. I have some table with a date column in it. I wish to have a key on yearweek(datecolumn). I don't want to allow having duplicate weeks in the table. Thanks for