Interesting question and interesting, enlightening discussion. Thanks, Ford!

Took a bit of research... Thanks for this great question!

Hah hah hah! Thanks, Andy!

Throughput

Sunglasses

Basketball

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Tom, as I said, I have a stake in this - I would like to see these issues clarified -, but I am not the one to...

TomThomson (3/4/2014)

---

Revenant (3/4/2014)

---

TomThomson (3/4/2014)

---

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

For SELECT DISTINCT, allowing ORDER BY to operate on columns not in the SELECT list would produce erratic and unpredictable behaviour. Consider this table:

Col1...

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Hmm... I am not a computer scientist and even less a programming language designer; however, I see that there could be a new rule...

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Hmm... I am not a computer scientist and even less a programming language designer; however, I see that there could be a new rule introduced that would...

TomThomson (3/4/2014)

---

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

For SELECT DISTINCT, allowing ORDER BY to operate on columns not in the SELECT list would produce erratic and unpredictable behaviour. Consider this table:

Col1 | Col2

-----+-----

...

Hugo Kornelis (3/4/2014)

---

Revenant (3/4/2014)

---

Hugo Kornelis (3/4/2014)

---

For SELECT DISTINCT, allowing ORDER BY to operate on columns not in the SELECT list would produce erratic and unpredictable behaviour. Consider this table:

Col1 |...

Hugo Kornelis (3/4/2014)

---

TomThomson (3/4/2014)

---

Nice question.

Hugo Kornelis (3/4/2014)

---

Koen Verbeeck (3/4/2014)

---

Nice question, but the explanation doesn't mention why the order of casting vs order by changes. (because of adding the T alias...

Indeed, this highlights an interesting point. Thanks, Anoo!

Virus