On Wed, 25 Jun 2003 15:29:20 -0400, Andrew Sullivan
<andrew@libertyrms.info> wrote:
>On Sat, Jun 14, 2003 at 07:33:19PM +0200, Sven K?hler wrote:
>>
>> "select *" should refelect the cosmetical order of the columns.
>
>Why? You asked for everything, and specified no order.
AFAICS it's a matter of standard conformance. SLQ92 says
in 4.8 Columns:
A column is described by a column descriptor. A column descriptor
includes:
[...]
- the ordinal position of the column within the table that con-
tains the column.
and in 7.9 <query specification>:
3) Case:
a) [deals with EXISTS]
b) Otherwise, the <select list> "*" is equivalent to a <value
expression> sequence in which each <value expression> is a
<column reference> that references a column of T and each
column of T is referenced exactly once. The columns are ref-
erenced in the ascending sequence of their ordinal position
within T.
4) The <select sublist> "<qualifier>.*" for some <qualifier> Q is
[similar to 3b]
Servus
Manfred
