[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Re: Medication viewing
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Re: Medication viewing |
Date: |
Thu, 19 Nov 2009 20:18:46 +0100 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
On Thu, Nov 19, 2009 at 08:36:41AM -0800, Jim Busser wrote:
> How would rows within columns be understood to be anything other
> than "Sorted" since you presumably apply no random function to
> sequence them?
In a relational database rows are by definition stored
unsorted in that at any one time the order rows are returned
is arbitrary unless a specific ordering is explicitely
applied during retrieval.
Physical rows can move around on-disk due to several
circumstances: backup/restore, database maintenance,
updating of row values, deletion of other rows, etc.
> You either fetch them "unsorted" by sequence of raw
> creation
No you can't because of the above. Also, that would NOT be
unsorted - it would be sorted by sequence of creation - as
you correctly point out !
>, which is essentially sorted by datetime
Unless the database engine applies an optimizing re-ordering
to the sequence of actual creation.
> If the list is displayed with its rows sequenced by substance name
> and within substance name by dosis and within dosis by plan what
> would you suggest is the grouping that should be offered? By
> substance?
Yep.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Re: Medication viewing, (continued)
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/18
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/18
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/18
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/18
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing,
Karsten Hilbert <=
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/28
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/29
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/30
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Jim Busser, 2009/11/19
- Re: [Gnumed-devel] Re: Medication viewing, Karsten Hilbert, 2009/11/19