Good morning,
Curiosity is a bad habit but here are the explanations ;-)
- The app users can create new records.
- The records are made of a Code, a Description, a Price and a Group.
- The Code is mask free but if the user wants to adopt a convention (eg
: a code starts with 2 digits of the group) and if he lacks of memory
(or just want to see how the other users did) the app must provide a way
to show a sample list of existing records for that group (a kind of
Coding convention reminder made of examples).
Now you know why I would need to choose n random rows. Anyway I'll do it
programmatically and I'm still confident with MaxDB :-)
Kind regards
Xav
Zabach, Elke a écrit :
Xavier CAMIER wrote:
Good morning,
I'd need a random function to choose a line sample of a table. In
searching into the mailing I found that "Eric Jain" unsucessfuly asked
such a question on August 2002. Is there something new since ?
Kind regards
Xav
There is no such functionality available in the kernel and there are no
plans to include it.
Just because of curiosity: Which problem do you want to solve with
random-fetches of resultrows?
Elke
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
