"As if there was no tomorrow" - exactly, because once you add another column suddenly $4 points to something completely different and you have to rewrite everything.
Not to mention $4 is completely arbitrary and it's impossible to tell without prior knowledge which field it's referencing.
The original query `SELECT pwd, cmd WHERE exit-code != 0` is both descriptive and won't break with future updates.
Not to mention $4 is completely arbitrary and it's impossible to tell without prior knowledge which field it's referencing.
The original query `SELECT pwd, cmd WHERE exit-code != 0` is both descriptive and won't break with future updates.