At 6:05 PM -0500 2000-02-04, Mr. Anthony R.J. Ball wrote:
>I guess my biggest complaint with the docs on them right now is that
>it doesn't really explain them... what can you do with them? Can you
>use them to return a list of rows, are they only good for applying
>to a field indivdually or a group.
>for instance I get the impression that with a function I can do something
>like plus_one(number) that will automatically add one to field number in
>the result set. But...
>could I write a function like get_categories(code) that looked up in
>all the categories that matched code and return them in a comma
>Or could I write a function that allowed me to return all the values
>of a field
>in a group by joined on a comma, stuff like that.
>I can't tell from the docs whether or not functions will be worth
>learning or not.
... doesn't explain "them" ...
... what can you do with "them" ...
... can you use "them" ...
That is a very broad description, and it's difficult to do anything
on the basis of it, because "them" isn't tied to anything specific.
In addition, Your original question had to do with trying
to understand how the MySQL functions work. Your message above now
is phrased in terms of writing your own functions. These are two
different things. In order to answer your questions (and possibly
improve the manual) we need information like:
- Which functions are you referring to? MySQL functions that you use
in SQL statements, such as those in the language reference chapter?
C API functions? I get the impression you're talking about the C API,
but I don't know.
- The questions in your first paragraph can all be answered "yes" or "no".
There are different functions for different things.
The "could I write" questions you raise above can be answered "yes",
because once you understand how MySQL's functions work, you can do
pretty much whatever you want.
I am unsure what to say about your "I get the impression" paragraph
above, because I'm not able to figure out what it means.
>On Fri, Feb 04, 2000 at 01:36:30PM -0800, sasha@stripped wrote:
>> "Mr. Anthony R.J. Ball" wrote:
>> > What I want is some solid documentation on mysql functions... I'm
>> > not even sure what they do or what I can do with them. Any of the
>> > books or documentation cover that well?
>> The manual does a pretty good job I thought :-) If not, let us
>>know, we'll fix
>> try to it.
> > Sasha Pachev
Paul DuBois, paul@stripped