> > If I order a query by ascending age, the youngest person gets > > rank 1, the second youngest gets rank 2, the third youngest gets rank 3, > > and if the fourth and fifth tie, they both get 4, and the next one gets 6. > > > > You know, rank? :) > > You could use a plPerl function. To do it with ties, you'd need some way of passing the function the ranking criteria with persistence between calls, which might have some startup issues. Wouldn't that also cause problems with multiple users calling the function simultaneously? -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
