1542

Officer

Koen Verbeeck (3/6/2014)

---

MysteryJimbo (3/6/2014)

---

Koen Verbeeck (3/5/2014)

Pfff, than you have never been in Belgium before 😀

If we wouldn't be having the most traffic jam congested cities in the world, you could...

MysteryJimbo (3/6/2014)

---

Depends on your definition of close and the road network. Roads in the UK are far from straight...

Francis

Revenant (3/4/2014)

---

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...

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 |...

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

-----+-----

...

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 in the second...

However it might be better to go westwards: Shrewsbury is much closer than Lichfield, it has Shrewsbury Castle and the Abbey...

Looks as if a duplicate got published instead of today's intended question.

Nice question.

My reaction to the comments saying it's "too easy" or "nice and easy" was at first to agree with tem, but then i looked at the number of wrong...

george sibbald (2/25/2014)

---

I think it is worth being aware that issuing a basic create statement, and using the GUI and just entering a database name might not give you the...

The Dixie Flatline (2/25/2014)

---

rodjkidd (2/25/2014)

---

Steve Jones - SSC Editor (2/24/2014)

---

I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to...

george sibbald (2/23/2014)

---

TomThomson (2/21/2014)

---

The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for database created...