-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 4 Feb 2009 11:01:45 +0100 Michael Mraka <[email protected]> wrote:
> % > Can't we just use those two fields, in the ORDER BY query? > % > % What two fields? > > order by decode(version, null, 1, 0), version Tried this before I went to the case but it didn't work, I think decode in PostgreSQL looks like it has a different meaning and signature, seems to be used for binary data. > or > order by CASE WHEN version IS NULL > THEN 1 > ELSE 0 > END, version Changed to this. Thanks, Devan - -- Devan Goodwin <[email protected]> Software Engineer Spacewalk / RHN Satellite Halifax, Canada 650.567.9039x79267 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAkmJkRgACgkQAyHWaPV9my64kwCfaAFAdhjj8hOnWRsWQ2sFdKOm wB4AoIhNiW/RfNfp19ROb18DqGtEYKnX =0HA/ -----END PGP SIGNATURE----- _______________________________________________ Spacewalk-devel mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-devel
