I have a following query: SELECT date FROM chng ORDER BY -date; Is there a way to use positional argument (hopefully that's the right term) instead of column name here? Something like this: SELECT date FROM chng ORDER BY -1;
This fails with a message "ORDER BY column number -1 out of range - should be between 1 and 1" This is not a big deal obviously since I can "ORDER BY 1 DESC" here. I'm just trying to simplify my code since SQL is generated at runtime. -- Nemanja Corlija <[EMAIL PROTECTED]>
