Subject | Re: The greater/lesser of a number of values |
---|---|
Author | ai_no_kareshi |
Post date | 2008-01-28T14:01:22Z |
> No. Version 2.1 will introduce these functions, maxvalue and minvalue.That certainly is good news. :)
> You can solve this by writing and UDF function that will take 3arguments
> and return min or max of themI've never written a UDF function, but I suppose I could. It seems
like a bit of a waste, though, if Version 2.1 is going to include such
functions anyway.
> What you should really do is normalize your tables by getting rid ofI appreciate your advice. While these three ratings may seem very
> repeating groups and put ratings in detail table.
similar in my example, though, in the actual database they are
actually three very distinct fields that are treated very differently
all over. Putting them in a separate table would significantly
complicate a great number of other queries.