Is it possible, that "SELECT *" returns records, where columns are
ordered in a different order, than the order they were
positioned/specified when table was created?
For example, lets assume that table T contains columns c1,c2,..c10.
Can this be possible, that the * (asterisk) shows the columns in a
different orderm the c1 and c10 changed their position for example:
"SELECT * FROM T"
c10, c2, c3, .., c9, c1.
I think you anderstood my question now.
The sql-standard doesn't tell about it nothing, but i have heard that
"selesct *" can produce columns in a random order in some situations.
Notice, that i'm not talking about "ORDER"-operator. I have heard that if one make a table with plenty of columns and adds plenty of indexes and constraints to the columns, then "select *" really will produce mistery column order.
Thank you for answering,