Re: find position of row in set of rows
Date: Sat, 30 Jan 2010 08:24:28 -0800 (PST)
Message-ID: <f0dffed0-fc73-4fee-b8df-9f2b46e4c68c_at_m31g2000yqb.googlegroups.com>
On Jan 28, 11:46 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
> Mladen Gogala <gogala.mla..._at_gmail.com> writes:
> > If you need a database to return you an ordered list, you are having
> > an application design issue.
>
> I thought you just added an "order the naive set" clause. :-)
>
> --
> Galen Boyer
>
> --- news://freenews.netfront.net/ - complaints: n..._at_netfront.net ---
"If you need a database to return you an ordered list, you are having an application design issue."
I think that this statement is a little overly broad. After all the order by clause exists for a reason. It is often desired to return an ordered set of data to make the data more useful. After all it is much easier to find the desired account, name, or other valid value off an ordered drop down list than using a list in random order!
Mgogala, has a point in that how you order a list can be both of questionable value and the ordering itself can be questionable based on how the dasta is stored and retrieved. Nevertheless, I will respectively disagree that ordering a set is wrong or in any way invalid in itself. It is how you order it and what you try to do with it that may be invalid.
IMHO -- Mark D Powell -- Received on Sat Jan 30 2010 - 10:24:28 CST