On Tue, Feb 3, 2009 at 6:34 PM, Jan Pazdziora <[email protected]> wrote:
> On Tue, Feb 03, 2009 at 06:26:19PM +0530, Gurjeet Singh wrote: > > > > > > How about > > > > > > order by decode(version, null, 1, 0), version > > > > Yup... that'll work, but will mess up the ordering if more than one of > > version's values is non-null. > > > > SQL> select * from t order by decode( a, null, 1, 0 ); > > > > A > > ---------- > > 1 > > 2 > > 4 > > 3 > > > > > > > > 6 rows selected. > > That's why my proposed solution was > > order by decode(version, null, 1, 0), version > > not just > > order by decode(version, null, 1, 0) > > Right.. I missed that last reference to version! -- gurjeet[[email protected] EnterpriseDB http://www.enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com
_______________________________________________ Spacewalk-devel mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-devel
